K
KerryMay
I don't know if I am going to explain this very well.
I have 10 files (each from a different person reporting data to me using a
standardized formI created for them), each file has 19 worksheets (each tab
is named amonth, quarterly, semi-annual, and annual) and each worksheet has 8
data points.
I need to add the data from cell A1, worksheet 1 from all ten files INTO
another file (basically summarizing the result) that will serve as a report.
I know how to do this for a worksheet. To capture all eight point from
everyone's worksheet 1, I have linked the first data point, erased the $'s,
and dragged the cell to copy the formula, which Excel automatically adjusts
for me.
When I move onto the next worksheet/tab, I cut andpaste the formula from the
last worksheet, change the tab name to th next one I want to work on, and
then drag, etc.
Problem is, its a lot of work to do. And to do this 19 times, I have to
click on each file 19 times. Or I have to type the tab name 10 times (to
replace the old tab name inthe old formula). Ugh.
Is there an easier way to do this?
I have 10 files (each from a different person reporting data to me using a
standardized formI created for them), each file has 19 worksheets (each tab
is named amonth, quarterly, semi-annual, and annual) and each worksheet has 8
data points.
I need to add the data from cell A1, worksheet 1 from all ten files INTO
another file (basically summarizing the result) that will serve as a report.
I know how to do this for a worksheet. To capture all eight point from
everyone's worksheet 1, I have linked the first data point, erased the $'s,
and dragged the cell to copy the formula, which Excel automatically adjusts
for me.
When I move onto the next worksheet/tab, I cut andpaste the formula from the
last worksheet, change the tab name to th next one I want to work on, and
then drag, etc.
Problem is, its a lot of work to do. And to do this 19 times, I have to
click on each file 19 times. Or I have to type the tab name 10 times (to
replace the old tab name inthe old formula). Ugh.
Is there an easier way to do this?