Forum Discussion
Possibly simple solution
Please find the attached with the formulas in place. You only need to enter the table number in column D and the names will be populated in the relevant table automatically as per the entered number.
Also, note that I have added a custom number formatting for all the table headers (green cells) so that they contain only a number but a prefix of Table is added to all of them. e.g. if you look at the cell F1, it contains a number 1 but the cell shows you the text "Table 1" where the "Table" prefix is added through the custom number formatting whereas the actual cell content is only 1.
If that takes care of your original question, please take a minute to accept the post with the proposed solution as a Best Response/Answer to mark your question as Solved.
Subodh_Tiwari_sktneerHiya, thankyou for this.
I'm still struggling with it, I really need to brush up! I have attached the document if you are able to implement the working solution in the file please that would be fantastic?! I literally just need the first and last name to appear under the table number headings when a corresponding number is typed in D2.
There are still names to go on the sheet so I have extended the range.
Many Thanks in advance
Please find the attached with the formulas in place. You only need to enter the table number in column D and the names will be populated in the relevant table automatically as per the entered number.
Also, note that I have added a custom number formatting for all the table headers (green cells) so that they contain only a number but a prefix of Table is added to all of them. e.g. if you look at the cell F1, it contains a number 1 but the cell shows you the text "Table 1" where the "Table" prefix is added through the custom number formatting whereas the actual cell content is only 1.
If that takes care of your original question, please take a minute to accept the post with the proposed solution as a Best Response/Answer to mark your question as Solved.