formula question?

Dunham19

New member
Joined
Feb 1, 2015
Messages
6
Reaction score
0
Points
0
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.
 
I SHOULD EXPLAIN A LITTLE FURTHER. A portion of the data I need to copy over from each worksheet is text. (Our sales force is required to type in their daily activity)
 
Back
Top