Hello, I need help with an Excel project. The main sheet in Excel is shown below. Currently, there are five rows in my Excel spreadsheet. However, this is variable. It can have one or a different value. Row 1 is fixed. It will not change.
I want to put the value and title in each row in a different page (I1 Coulumn). I want the value in the ID column to come as the page name. For example, as follows;
This should be the case for other pages.
I want to link the “Main Description” field in the P3 column. The link should be to the Description field belonging to the ID on the “MAIN” page. For example;
P3 column on page 123 should be linked to G2 on the MAIN page.
P3 column on page 456 should be linked to G3 on the MAIN page.
P3 column on page 789 should be linked to G4 on the MAIN page.
P3 column on page 101 should be linked to G5 on the MAIN page.
P3 column on page 111 should be linked to G6 on the MAIN page.
I’m sharing the INPUT and OUTPUT Excel spreadsheets. Can you help me?
OUTPUT.xlsx (22.9 KB)
INPUT.xlsx (11.2 KB)
