Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Making a spread sheet template
Here is my situation. Every month export two reports from QuickBooks into
Excel. Report #1 is on one sheet and report #2 is on sheet two. I then set up several new rows that use various functions to provide me with data derived from the information I exported. This new data is needed to fill out sales and use tax forms for the parish and state tax agencies. How can I export this monthly information into a template so that all the programming does not have to be recreated? I would really appreciate any help with this. I can send a copy of the spreadsheet if that helps with this issue. Kyle |
#2
|
|||
|
|||
Try starting with Excel! Dataimport external data(named data
source"Qickbook, etc"). Once data is imported and you have your additional colums, rows set up with formulas, next month open spreadsheetdatarefresh data! This will import the new data into your formatted spreadsheet. Pat F "Kyle" wrote: Here is my situation. Every month export two reports from QuickBooks into Excel. Report #1 is on one sheet and report #2 is on sheet two. I then set up several new rows that use various functions to provide me with data derived from the information I exported. This new data is needed to fill out sales and use tax forms for the parish and state tax agencies. How can I export this monthly information into a template so that all the programming does not have to be recreated? I would really appreciate any help with this. I can send a copy of the spreadsheet if that helps with this issue. Kyle |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I make a new spread sheet pop up, based on an entry in a c. | Excel Discussion (Misc queries) | |||
Excel window in spread sheet? | Excel Discussion (Misc queries) | |||
new sheet created 'on the fly' from template in same workbook - H. | Excel Worksheet Functions | |||
Making the Sheet a relative value? | Excel Worksheet Functions | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |