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