Copying multiple rows between sheets - Including formulas, formatting

Rune Østerhus

Hello

I'm having a hard time figuring this out.

I have two sheets. On the target sheet I have a set of formulas and hyperlinks.

On the other sheet I need to have basically everything (Except a few rows) under the existing parts of target sheet.

I have tried everything.

Ctrl + C/V -> Got me the text over, but all in white, an no formulas.

Copy/Move this to another sheet - Got the formatting and parent settings, but still no formulas.

There MUST be a way to export the whole thing, without having to either make all the formatting AND formulas over again?

I read that if I want to copy a formula I need to double-click the cell and select and copy/paste. That doesn't work. I have many cells with formulas.

I would copy it the other way, but that doesn't do any difference. Formulas have to be copied either way.

Can anyone please help?

Regards

Rune Østerhus

Andrée Starå

Hi @Rune Østerhus

I'd recommend saving a copy of the sheet (save as new) and then remove the rows.

Would that work/help?

I hope that helps!

Have a fantastic day & Happy New Year!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Rune Østerhus

Hi @Andrée Starå

Thanks for the quick response!

Not sure wich sheet to "save as". And which rows to remove.

Rune

Andrée Starå

@Rune Østerhus

Happy to help!

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)