Hello guys,
this is my first thread on this site!
I am pretty new to MS Excel and currently having a problem with following issue:
I have a table that looks the following way:
picture_no1.JPG
Everything in this table I can edit, Y and X are values between 1 and 5.
From this table I want to produce a table that looks the following:
picture_no2.JPG
When I change something in the first table, I'd like it to automatically change the position in table 2 as well.
Or in case I add a new person, I'd like that also to pop up in the second table as well.
Can anybody help me please? I don't even have the slightest idea how to start
Best regards!
Bookmarks