Hi,
Hope you are all having a lovely day and staying safe. I recently downloaded a template spreadsheet and wanted to change it a little. I have only started learning Excel so please excuse me, I would have searched but don't really know what to search for and if it's even possible.
I have 11 spreadsheets open in a workbook.
Dashboard, Name, Name (2), Name (3) etc
Ryan
Hope you are all having a lovely day and staying safe. I recently downloaded a template spreadsheet and wanted to change it a little. I have only started learning Excel so please excuse me, I would have searched but don't really know what to search for and if it's even possible.
I have 11 spreadsheets open in a workbook.
Dashboard, Name, Name (2), Name (3) etc
- First I need to get the name from Dashboard D2
- Then search across the 10 spreadsheets for that name which will appear in Name B9, Name (2) B9, Name (3) B9 etc
- Go across the column to Name AB9, Name (2) AB9, Name (3) AB9 etc
- Look down the column and if there is something in the cell return some text to Dashboard J2
Ryan