ATTENTION: You are viewing a page formatted for mobile devices; to view the full web page, click HERE.

Main Area and Open Discussion > Living Room

Any VBA experts?



I have an Excel sheet with formulas and text in hundreds of cells.

Is there a way to click a button and add this sheet to the active workbook, in any xls file I have opened?

Some formulas refer to a sheet with a specific name, so when this sheet is present in the workbook, the formulas must work.


as usual, more info is your friend

copying a sheet into a book is easy, but you may well have issues with the formulas (depending on what they are and what you're trying to do)

and it sounds like not everything in the formula sheet is applicable in every scenario you might use it in, so it may be that using the process you've described isn't a very efficient solution

I have a sheet with lots of formulas and text called TEMPLATESHEET. This sheet is stored in a TEMPLATEWORKBOOK.

When I open any xls file, I want a macro that will insert to the active workbook, the TEMPLATESHEET.

However, the TEMPLATESHEET, has some formulas that refer to a sheet called REFERENCESHEET.

So, when the xls file I open has a sheet with the same name, REFERENCESHEET, I want the formulas for the TEMPLATESHEET to link to the REFERENCESHEET.

Would that be possible? I may have to search-and-replace the #REF of the TEMPLATESHEET to match the REFERENCESHEET, unless the TEMPLATESHEET will preserve the references and have them working.

I don't think there is more info than that available.


[0] Message Index

Go to full version