Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Populating Data
I have 2 fairly large reports (that have 10 tabs of data) that I do every
week and would like to know if there is a way that I don't have to re-create these reports each week. Here is what I am currently doing: I export specific information from ACT! into Excel (this information changes from week to week). Then I insert several additional columns throughout so that I can perform various calculation totals. Once this is done I copy/paste the information that I need into my reports. Hers' my question: Is there a way that once I have my Exported data ready to go, that I can have the data necessary to populate automatically over to my reports rather than having to copy/paste while keeping the format (colors, column widths, formulas, etc.) in tact? Any Help would be greatly appreciated!! Thanks! Rwilson130 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Populating Data
you can have your reports in seperate excel files, then have them refernce
the one file that you update every week, this should populate all your reports automaticaly "RWilson130" wrote: I have 2 fairly large reports (that have 10 tabs of data) that I do every week and would like to know if there is a way that I don't have to re-create these reports each week. Here is what I am currently doing: I export specific information from ACT! into Excel (this information changes from week to week). Then I insert several additional columns throughout so that I can perform various calculation totals. Once this is done I copy/paste the information that I need into my reports. Hers' my question: Is there a way that once I have my Exported data ready to go, that I can have the data necessary to populate automatically over to my reports rather than having to copy/paste while keeping the format (colors, column widths, formulas, etc.) in tact? Any Help would be greatly appreciated!! Thanks! Rwilson130 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Populating Data
Thank you for your response! Can you tell me how to reference the file?
Thanks! "stabfpo" wrote: you can have your reports in seperate excel files, then have them refernce the one file that you update every week, this should populate all your reports automaticaly "RWilson130" wrote: I have 2 fairly large reports (that have 10 tabs of data) that I do every week and would like to know if there is a way that I don't have to re-create these reports each week. Here is what I am currently doing: I export specific information from ACT! into Excel (this information changes from week to week). Then I insert several additional columns throughout so that I can perform various calculation totals. Once this is done I copy/paste the information that I need into my reports. Hers' my question: Is there a way that once I have my Exported data ready to go, that I can have the data necessary to populate automatically over to my reports rather than having to copy/paste while keeping the format (colors, column widths, formulas, etc.) in tact? Any Help would be greatly appreciated!! Thanks! Rwilson130 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Populating Data
Użytkownik "RWilson130" napisał w wiadomo¶ci ... Thank you for your response! Can you tell me how to reference the file? You can link/reference *.xls files in this way: file1.xls - name of base file (with ACT! export ) sheet1 - name of worksheet in this file c2 - cell with value you need in report in desired cell in file2.xls (report file) you can type =[file1.xls]sheet1!c2 this works when both *.xls files are in the same computer directory. If not, you should type full path to file1.xls like this: ='c:\my_documents\excel\weekly_ballance\[file1.xls]sheet1'!c2 -- ============================== Janusz Pawlinka |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto-populating file based on conditions | Excel Discussion (Misc queries) | |||
Auto Populating and Formatting Data | Excel Discussion (Misc queries) | |||
Help with auto populating cells. | Excel Worksheet Functions | |||
Auto populating date field | Excel Discussion (Misc queries) | |||
Auto populating fields | Excel Worksheet Functions |