On a summary page I have cell range pulling data from cells a1:g20 in a sheet named SHEET1 and on that same summary page i need a another section to pull the data from the exact sames cells but on a different worksheet (SHEET2) and I need to do this over and over and over again. 150+ times. Can I create a formula that will do this and all I have to change is the sheet name?
if it is using the indirect function, I do not understand how to use this to specify a worksheet and multiple cells.
PLEASE PLEASE PLEASE HELP.
if it is using the indirect function, I do not understand how to use this to specify a worksheet and multiple cells.
PLEASE PLEASE PLEASE HELP.