J
JW73
I just recently upgraded to Excel 2007, and I've been working with tables in
a new spreadsheet to keep track of employee training courses, but I'm having
difficulty figuring out a way to reduce time involved in updating data -
here's the basic setup:
Sheet 1 has the only user-input section, basic checkbox setup to keep track
of completions.
Sheet 2 compiles all the data into tables for appropriate course groups,
with lots of crosslinking due to courses being flagged for multiple groups.
Sheets 3 and up have copies of the appropriate tables on sheet 2, linking
course group recommendations to various job positions.
The problem:
I've coded everything to work smoothly with the current setup, updating
completions on all appropriate sheets whenever the user tags a checkbox on
the primary sheet. What I can't figure out is, is there a way to set this up
so that if I add a new row to one of the tables on sheet 2, it will adjust
the copies of that table on any other sheet as well? With the current setup,
I'll have to manually re-copy the table to each other sheet that it appears
on - I'm pretty sure Excel has a way to do this now, but I've been unable to
find a way so far - any advice would be greatly appreciated.
a new spreadsheet to keep track of employee training courses, but I'm having
difficulty figuring out a way to reduce time involved in updating data -
here's the basic setup:
Sheet 1 has the only user-input section, basic checkbox setup to keep track
of completions.
Sheet 2 compiles all the data into tables for appropriate course groups,
with lots of crosslinking due to courses being flagged for multiple groups.
Sheets 3 and up have copies of the appropriate tables on sheet 2, linking
course group recommendations to various job positions.
The problem:
I've coded everything to work smoothly with the current setup, updating
completions on all appropriate sheets whenever the user tags a checkbox on
the primary sheet. What I can't figure out is, is there a way to set this up
so that if I add a new row to one of the tables on sheet 2, it will adjust
the copies of that table on any other sheet as well? With the current setup,
I'll have to manually re-copy the table to each other sheet that it appears
on - I'm pretty sure Excel has a way to do this now, but I've been unable to
find a way so far - any advice would be greatly appreciated.