Importing cells into an excel spreadsheet from another spreadsheet
- From: pmelland@xxxxxxxxx
- Date: 15 Aug 2006 12:54:58 -0700
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.
.
- Prev by Date: Re: Auto replace, can it easy be done?
- Next by Date: Re: Converting a number to a time period HELP
- Previous by thread: Per hour-of-day summary chart
- Next by thread: Excell 2007 messing up graphics
- Index(es):
Relevant Pages
|
