Hi
I have two tabs which I'm using to track hours worked (there are other tabs too but I doubt these matter for this query). Tab 2 is basically a database, an example of how it appears is this;
A B C D E
1 Employee ID Employee Name Week 20 week21 week22 ...etc
2 1001 Jim 35 35 35
3 1002 Bob 35 35 35
4 1003 Edd 35 40 40
Tab 1 contains a whole host of data, but specifically pulls through data from other tabs (in this case hours worked) and preforms calculations with the data (holiday earned, wages, etc). The data displays only one employee at a time, and I have a Dropdown box containing each Employee ID which I use to switch between IDs.
eg
A B C D E
1 Employee ID (selected via list) Employee Name (by lookup to tab 2)
2 Week number Week 20 week21 week22 ...etc
3 Hours worked (basic) (all data here displayed using lookups to other tabs or calculations)
4 Holiday earned " "
5 Bonuses paid " "
etc
Currently this just displays data that I have to manually update on each other tab. What I'd really like (nd I assume if this is possible it will only be using VBA) would be to be able to overtype the data as it appears on tab 1, and then hit a button that goes to the other tabs and auto updates the data tables there. EG in this case I update the hours worked for the selected employee and the macro goes and updates tab 2.
does this sound possible? It feels complicated to me, but keen to see what you think!
thanks, Iain
I have two tabs which I'm using to track hours worked (there are other tabs too but I doubt these matter for this query). Tab 2 is basically a database, an example of how it appears is this;
A B C D E
1 Employee ID Employee Name Week 20 week21 week22 ...etc
2 1001 Jim 35 35 35
3 1002 Bob 35 35 35
4 1003 Edd 35 40 40
Tab 1 contains a whole host of data, but specifically pulls through data from other tabs (in this case hours worked) and preforms calculations with the data (holiday earned, wages, etc). The data displays only one employee at a time, and I have a Dropdown box containing each Employee ID which I use to switch between IDs.
eg
A B C D E
1 Employee ID (selected via list) Employee Name (by lookup to tab 2)
2 Week number Week 20 week21 week22 ...etc
3 Hours worked (basic) (all data here displayed using lookups to other tabs or calculations)
4 Holiday earned " "
5 Bonuses paid " "
etc
Currently this just displays data that I have to manually update on each other tab. What I'd really like (nd I assume if this is possible it will only be using VBA) would be to be able to overtype the data as it appears on tab 1, and then hit a button that goes to the other tabs and auto updates the data tables there. EG in this case I update the hours worked for the selected employee and the macro goes and updates tab 2.
does this sound possible? It feels complicated to me, but keen to see what you think!
thanks, Iain
