Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linked Worksheets
I am trying to link worksheets, data from Quickbooks that I export from
Quickbooks into an excel spreadsheet and one that i have created.I have figured out how to link them but te problem is every month I have to import the information and instead of overwriting it creates a new page. I need it to overwrite the infomation every month and am not sure how to make that happen. Any help would be appreciated. Thanks -- Karen |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linked Worksheets
Maybe you could just create a new worksheet "Current". Then copy the current
months data into that worksheet. Then all the formulas would still point to Current, but the data will have been updated. Karen wrote: I am trying to link worksheets, data from Quickbooks that I export from Quickbooks into an excel spreadsheet and one that i have created.I have figured out how to link them but te problem is every month I have to import the information and instead of overwriting it creates a new page. I need it to overwrite the infomation every month and am not sure how to make that happen. Any help would be appreciated. Thanks -- Karen -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
do not chart cells linked from worksheets that are blank | Charts and Charting in Excel | |||
Question about deleting rows from sorted linked worksheets | Excel Worksheet Functions | |||
How do I navigate on a click between linked worksheets in Excel? | Excel Worksheet Functions | |||
Offset, indirect, match function limitation on linked worksheets. | Excel Worksheet Functions | |||
Linked worksheets | Excel Discussion (Misc queries) |