Hi
I have spend a lot of time to figure it out myself but I can not crack it. I wonder if someone can help me.
There are two sheets:
1) profiles_available
2) profiles_selected
On sheet profiles_available I have a following table
Row1 Col A Col B Col C Col D Col E Row2 Standard wk B/H Mon noname xmas Row3 Sunday 2.31 10 8 0 Row4 Saturday 11.27 10 11 0 Row5 Friday 17.57 20 27 0 Row6 Thursday 17.57 20 27 25 Row7 Wednesday 17.57 20 27 25 Row8 Tuesday 17.57 20 0 25 Row9 Monday 16.14 0 0 25
On sheet profiles_selected I have a following table
Row1 Col B Col C Col D Col E Row2 Selected profile → xmas Standard wk B/H Mon Row3 Sunday Row4 Saturday Row5 Friday Row6 Thursday Row7 Wednesday Row8 Tuesday Row9 Monday
Now I would like to have a formula that would help me to populate this empty table on sheet profiles_selected using the vertical and horizontal headings (in bold RED).
Row1 Col B Col C Col D Col E Row2 Selected profile → xmas Standard wk B/H Mon Row3 Sunday 0 2.31 10 Row4 Saturday 0 11.27 10 Row5 Friday 0 17.57 20 Row6 Thursday 25 17.57 20 Row7 Wednesday 25 17.57 20 Row8 Tuesday 25 17.57 20 Row9 Monday 25 16.14 0
I have attached spreadsheet with both sheets on it (plus example of before and after). If anyone can help me out I would appreciate this a lot.
Cheers
Bookmarks