Index & Match with the name of Tab

[ypurcaro]

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

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

 

[ypurcaro]

Hi - you can have whatever layout you like.

But if you present one layout, and then we suggest a solution for that layout, and then you apply that solution to a different layout, then it's possible it won't work, unless you adapt the solution to take the new layout into account.

I'll take a look at the new layout shortly.

I appreciate your help.