Rowby Goren

asked on

# Copying just the formulas from one spreadsheet to another

I have a spreadsheet with forumlas in some of the columns.

The various formulas are in row "B".

Is there a way to copy row "B" but just the formulas -- so I can paste those formulas into other spreadsheets.

The various columns each have a different formula.

Thanks

Rowby

The various formulas are in row "B".

Is there a way to copy row "B" but just the formulas -- so I can paste those formulas into other spreadsheets.

The various columns each have a different formula.

Thanks

Rowby

ASKER

Thanks, Brian --

Hmmm.

I just tried that but.... the Paste Special is not working -- apparently because I'm copying it into a totally separate spreadsheet.

Do all of the spreadsheets have to be in the same workbook for copy >> paste >special to work???

Rowby

Hmmm.

I just tried that but.... the Paste Special is not working -- apparently because I'm copying it into a totally separate spreadsheet.

Do all of the spreadsheets have to be in the same workbook for copy >> paste >special to work???

Rowby

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

I think it was another instance of excel. Stay tuned. I'll open all the files in one instance.

Rowby

Rowby

ASKER

Hi.

Opened it all in one stance of Excel and Copy Special - Formula WORKED!

Thanks!

Opened it all in one stance of Excel and Copy Special - Formula WORKED!

Thanks!

Great! Thanks, Rowby.

Copy the cells and then do a PasteSpecial Formulas. In the image below, the mouse is pointing at this.

Regards,

Brian