| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keeping Workbook Name Out of Sheet When Copying to Different Book
I run a hockey draft that requires me to copy worksheets into a master sheet
but I need to know how to copy them without the formulas referencing the workbook that they came from as the formula will only work if it stays general. i.e. =IF('MasterI12'=1,"Correct", "") rather than =IF('CopyofSheet4MasterI12'=1,"Correct",""). Right now I have to doa search and replace on every sheet I copy into the master sheet and it is very painful :( Thx. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying an Excel sheet keeping the formulas in the copy linked to | Excel Discussion (Misc queries) | |||
| Keeping a Macro in a new book | Excel Worksheet Functions | |||
| how do i set up book keeping accounts? | New Users to Excel | |||
| Where can I find a VAT book keeping template? | Excel Discussion (Misc queries) | |||
| how do I set up book keeping on office | Excel Worksheet Functions | |||
Threaded Mode
