P
pmelland
Hello,
I am network administrator wanting to use excel to create a report for
a client. The report is currently compiled from 7 other spreadsheets by
hand (2-4 hour process). The information that is in the 7 other
spreadsheets is in the same format every week. But to be safe I would
like to extract the information from those spreadsheets from cells that
are in the same row as the store number. So what I want is a
macro/program to find the store reference number then go down the row
to the cells that have the information that is needed in the new
report. Although I am not an excel expert I have used it for years for
basic tables and tracking information. How do I automate the report
compilation? Is it through macros (if so can you tell me where to get
started)? Can it be done? Being a network admin I really appreciate it
when someone tries to find an answer about something before I get a
call, so i have spent two hours searching for my answer to no avail.
Thank you for any help you may provide.
I am network administrator wanting to use excel to create a report for
a client. The report is currently compiled from 7 other spreadsheets by
hand (2-4 hour process). The information that is in the 7 other
spreadsheets is in the same format every week. But to be safe I would
like to extract the information from those spreadsheets from cells that
are in the same row as the store number. So what I want is a
macro/program to find the store reference number then go down the row
to the cells that have the information that is needed in the new
report. Although I am not an excel expert I have used it for years for
basic tables and tracking information. How do I automate the report
compilation? Is it through macros (if so can you tell me where to get
started)? Can it be done? Being a network admin I really appreciate it
when someone tries to find an answer about something before I get a
call, so i have spent two hours searching for my answer to no avail.
Thank you for any help you may provide.