Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pulling one cell from Multiple sheets to one sheet | Excel Discussion (Misc queries) | |||
Need help with a formula pulling data from mutilple sheets | Excel Discussion (Misc queries) | |||
Pulling Data in Excel | Excel Worksheet Functions | |||
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
pulling info from multiple sheets | Excel Discussion (Misc queries) |