DataAnalyst
New Member
- Joined
- Mar 23, 2012
- Messages
- 44
Hi everyone,
I'm in a crunch which I have to manually create about 40 one-page reports from a table of values. The reports are for the people I support, and I plan to make each report on a separate tab in the excel worksheet with the table of values.
The names of the report recipients are across the top with the value labels down the side, this is how the final report will look. The first report is for Name1, second Name2, etc.
So the report will have formulas to bring in the data values in each row like this:
Label Formula
Metric1 =Datasheet!FirstRowName1
Metric2 =Datasheet!2ndRowName1
etc.
My original idea was to make the reports and manually copy the values for each person. I like formulas better in case we use this again in the future, but I still have to manually insert them in each report.
Is there a simple way to increment these formulas as I create each new tab?
So then when I copy the tab with the code above it would be like this:
Metric1 = Datasheet!FirstRowName2
Metric2 = Datasheet!2ndRowName2
Is there a quick and simple way to do this? I've looked at the Offset and Indirect functions, but I've never used them before and don't have time to learn them now since this is a crunch. Our outside programmers were supposed to do this and didn't, and the reports have to be ready for management to review by Monday afternoon.
Thanks for any help you can provide!
I'm in a crunch which I have to manually create about 40 one-page reports from a table of values. The reports are for the people I support, and I plan to make each report on a separate tab in the excel worksheet with the table of values.
The names of the report recipients are across the top with the value labels down the side, this is how the final report will look. The first report is for Name1, second Name2, etc.
So the report will have formulas to bring in the data values in each row like this:
Label Formula
Metric1 =Datasheet!FirstRowName1
Metric2 =Datasheet!2ndRowName1
etc.
My original idea was to make the reports and manually copy the values for each person. I like formulas better in case we use this again in the future, but I still have to manually insert them in each report.
Is there a simple way to increment these formulas as I create each new tab?
So then when I copy the tab with the code above it would be like this:
Metric1 = Datasheet!FirstRowName2
Metric2 = Datasheet!2ndRowName2
Is there a quick and simple way to do this? I've looked at the Offset and Indirect functions, but I've never used them before and don't have time to learn them now since this is a crunch. Our outside programmers were supposed to do this and didn't, and the reports have to be ready for management to review by Monday afternoon.
Thanks for any help you can provide!
Last edited by a moderator: