There are two things I am attempting to do. One is for the sheet named 'Index' and the other is for the sheet 'Agents'
INDEX - The macro for the index is working fine. If I add sheets, column A keeps adding hyperlinks for them. I am trying to consolidate data from the cell B5 across those sheets to give me the date in column B. Similarly, I need the outcome column to be populated from B50. Please note that these should continue as I keep adding sheets to the workbook.
AGENTS - I need values added in columns B, C and D. Column B needs to give me the count of cell B2 across the sheets but that needs to match with the name in column A. Column C and D needs to give me a count of B 50 but again needs to match the agent name.
Not sure if this is clear at all but the main thing is that the number of sheets are infinite and hence the macro cannot be limited to the 11 sheets that are there as sample.
INDEX - The macro for the index is working fine. If I add sheets, column A keeps adding hyperlinks for them. I am trying to consolidate data from the cell B5 across those sheets to give me the date in column B. Similarly, I need the outcome column to be populated from B50. Please note that these should continue as I keep adding sheets to the workbook.
AGENTS - I need values added in columns B, C and D. Column B needs to give me the count of cell B2 across the sheets but that needs to match with the name in column A. Column C and D needs to give me a count of B 50 but again needs to match the agent name.
Not sure if this is clear at all but the main thing is that the number of sheets are infinite and hence the macro cannot be limited to the 11 sheets that are there as sample.