Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automate Excel report to place certain data into existing report?
I get an Excel spreadsheet report that I need to bring over the store number
to and existing report. The common field for both is the client number. I get this report every week and would like to automate the process. Right now I have to go line by line through hundreds of stores. Is there a way I can set this to automatically do what I am asking? Thank you for your help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automate Excel report to place certain data into existing report?
You might try looking at VLookup to get you started, if you are trying to
find a value in various worksheets. -- David "Craig Harrison" wrote: I get an Excel spreadsheet report that I need to bring over the store number to and existing report. The common field for both is the client number. I get this report every week and would like to automate the process. Right now I have to go line by line through hundreds of stores. Is there a way I can set this to automatically do what I am asking? Thank you for your help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automate Excel report to place certain data into existing report?
yes, it's possible to automate such report management in excel. best way is
to use macros or, even better, VBA. But, for start, vlookup will make finding information easier... "Craig Harrison" <Craig wrote in message ... I get an Excel spreadsheet report that I need to bring over the store number to and existing report. The common field for both is the client number. I get this report every week and would like to automate the process. Right now I have to go line by line through hundreds of stores. Is there a way I can set this to automatically do what I am asking? Thank you for your help. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automate Excel report to place certain data into existing repo
Please correct me if I am wrong but VLookup is not exactly an automated way
to take my report I need to write and extract data from a store report. Each of these reports are updated daily. I would like to have some method that would automatically synch my report and extract data from the store report. Is this possible? Thanks again, Craig "David" wrote: You might try looking at VLookup to get you started, if you are trying to find a value in various worksheets. -- David "Craig Harrison" wrote: I get an Excel spreadsheet report that I need to bring over the store number to and existing report. The common field for both is the client number. I get this report every week and would like to automate the process. Right now I have to go line by line through hundreds of stores. Is there a way I can set this to automatically do what I am asking? Thank you for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In EXCEL 2002 format cell with existing data. | Excel Discussion (Misc queries) | |||
Despite data existing in Excel 2002 spreadsheet Find doesn't find | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Excel 2003, Convert EXISTING Worksheet Data to XML? | Excel Discussion (Misc queries) | |||
How do I automate upload of data from one excel file to another? | Excel Worksheet Functions |