Hello,
I hope all is well. I don't know if we can use the index and match in this case. I tried, but I failed because I don't know how do I point the code to the name of the tab. I hope I could get some help on this one. Thank you in advance.
Table I need to fill
This is the table I have all information, we call it score card. The spreadsheet has 4 tabs - East, West, North & South. The table is like below, it's more like a horizontal table. What I need to do is once I entered the hour to this table, it will also fill out the above table. Remember, this is on the tab named "West".
I hope all is well. I don't know if we can use the index and match in this case. I tried, but I failed because I don't know how do I point the code to the name of the tab. I hope I could get some help on this one. Thank you in advance.
Table I need to fill
Date | Total Hour | Location |
01/02/2022 | 120 | West |
02/02/2022 | 135 | West |
03/01/2022 | 150 | West |
04/01/2022 | 110 | West |
This is the table I have all information, we call it score card. The spreadsheet has 4 tabs - East, West, North & South. The table is like below, it's more like a horizontal table. What I need to do is once I entered the hour to this table, it will also fill out the above table. Remember, this is on the tab named "West".
Date | 01/02/2022 | 02/02/2022 | 03/01/2022 | 04/01/2022 | 05/01/2022 |
Total Hour | 120 | 135 | 151 | 110 | |
Vacation Hour | 50 | 45 | 35 | 25 | |
Regular Hour | 110 | 90 | 75 | 80 |