Copy multiple sheets with formulas to a new workbook without creating a link

[drousyblinx]

I have a master workbook where I keep a database of sheets with formulas in them.


Is there a macro or other method someone would know, that would allow me to copy a subset of sheets, which contain formulas referencing only that subset, into a new workbook, without adding an external link?


e.g. copy Workbook A: Sheet 1, Sheet 2, Sheet 3 to Workbook B. Formulas remain as Sheet 1, 2 3, not '[Workbook A]Sheet1'

I know I could expose the formulas and copy to notepad then copy back to the new Excel workbook but this would be quite cumbersome.

 

[Michael M]

you could use Find / Replace to replace the = sign with a ? >> copy >>paste in new sheet>>replace ? with =
If you want to do it via macro you will need to provide workbook name / location, etc....as well as sheet names

 

[drousyblinx]

you could use Find / Replace to replace the = sign with a ? >> copy >>paste in new sheet>>replace ? with =
If you want to do it via macro you will need to provide workbook name / location, etc....as well as sheet names

That's a good suggestion.

Unfortunately the sheet names are different every time. Would you know one I could use that lets me choose the sheets?

 

[Michael M]

I'm assuming you mean a macro here...

Would you know one I could use that lets me choose the sheets?

If so, you will need to provide much more info than you have so far...

You can also do a copy >> Paste Special>> formulas only