Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying worksheets into a new workbook changes information on shee
I have a 2003 workbook that has multiple worksheets in it. Once the first
worksheet is filled out, it populates fields on the other 5 worksheets. This workbook is a template. Each file(workbook) is a different client. One of the sheets, lets say sheet 4, needs to be copied from each of these workbooks into a single workbook for reporting purposes. I copy sheet 4 from workbook 1 into a new book. Then I go to workbook 2 to copy worksheet 4 into the new book. The client name on sheet 1 changes to the client name on sheet 2. Now I have 2 sheets with the same name and information, but it doesn't change any of the calculated fields on each of the sheets. If I copy sheet 4 from workbook 3, that client's name appears on the other two sheets, and so on. Question, how do I copy these sheets without having it change the information each time a new sheet is added? I have renamed each of the sheets in the original workbook, but I guess since the info is still the same, it still changes it. Help! I don't want to retype all the information on each of the sheets in the new workbook! Thanks for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying related information between worksheets | Excel Discussion (Misc queries) | |||
Copying information into another workbook | Excel Worksheet Functions | |||
Copying information from multiple worksheets into one | Excel Discussion (Misc queries) | |||
How can I enter information in a different cell in one Excel shee. | Setting up and Configuration of Excel | |||
How to search multiple worksheets in a workbook for information? | Excel Discussion (Misc queries) |