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 |
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 |
All times are GMT +1. The time now is 11:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com