T
Ter
I have a main spreadsheet that currently uses VLOOKUP to
locate data on 12 (month) separate spreadsheets for 115
different people. Each of the 12 spreadsheets contain 1
large row of monthly stats for each person - one row per
person. I should be able to combine the data on one
spreadsheet, if it would work better. There are several
variable, such as name/group/area that are currently
included in the formula. The table containing the
VLOOKUP, produces two graphs and a chart displaying the
monthly and cumulative stats for each person (and two
graphs displaying where they stand in relation to the
other people in their group).
QUESTION - is this the most efficient way to do this, if
not can you make a recommendation? I will also be
shipping a section of the main spreadsheet out to other
people, and want to avoid the "This workbook contains
links to other data sources" dialogue because they will
not have rights to the data source.
I used to be familiar with writing Macros in Excel 95, but
am new to VBA functions.
All help appreciated.
locate data on 12 (month) separate spreadsheets for 115
different people. Each of the 12 spreadsheets contain 1
large row of monthly stats for each person - one row per
person. I should be able to combine the data on one
spreadsheet, if it would work better. There are several
variable, such as name/group/area that are currently
included in the formula. The table containing the
VLOOKUP, produces two graphs and a chart displaying the
monthly and cumulative stats for each person (and two
graphs displaying where they stand in relation to the
other people in their group).
QUESTION - is this the most efficient way to do this, if
not can you make a recommendation? I will also be
shipping a section of the main spreadsheet out to other
people, and want to avoid the "This workbook contains
links to other data sources" dialogue because they will
not have rights to the data source.
I used to be familiar with writing Macros in Excel 95, but
am new to VBA functions.
All help appreciated.