| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy worksheet to 2nd workbook but have no reference to 1st workbo
I am necessarily (someone else's system) working with 12 plus different
workbooks which are badly formatted so that they can't be easily printed. So I have created a 'sheet2' which has references to pick out the data I want, arranged as I want it to print it. However, when I copy one of these 'sheet2s' to another workbook, all of the references e.g. =a1 have the reference to the first workbook e.g. = [workbook1]Sheet1!A2 I am more than happy with the 'sheet1' part but don't want the [workbook1] part as, of course, this won't work when I put it in [workbook2]! Help please! -- Regards i4004 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to Copy Pivot Table Data to Another Worksheet in Same Workbo | Excel Worksheet Functions | |||
| Spreading formulas down the workbook while pulling from 2nd workbo | Excel Discussion (Misc queries) | |||
| Link from worksheet in one workbook to worksheet in another workbo | Excel Discussion (Misc queries) | |||
| Link from worksheet in one workbook to worksheet in another workbo | New Users to Excel | |||
| Macro to open workbook and copy and paste values in to orig workbo | Excel Worksheet Functions | |||
Threaded Mode
