S
sdosssdoss
Hi
I am constructing a tool with ~100 sheets that will act as scorecards
and 1 summary sheet which will pull the total score info from each
scorecard.
In order to efficiently construct this tool I could use some help with
the following:
1) How can I design a macro that will modify (in any way) all of the
100 scorecards?
2) Once I have figured out #1 above, how do I reference the total on
each scorecard (same cell) to the summary sheet (into different cells)
without doing it manually.
Any help would be greatly appreciated.
Thanks
I am constructing a tool with ~100 sheets that will act as scorecards
and 1 summary sheet which will pull the total score info from each
scorecard.
In order to efficiently construct this tool I could use some help with
the following:
1) How can I design a macro that will modify (in any way) all of the
100 scorecards?
2) Once I have figured out #1 above, how do I reference the total on
each scorecard (same cell) to the summary sheet (into different cells)
without doing it manually.
Any help would be greatly appreciated.
Thanks