J
jkiser
I have a workbook with a large number of worksheets; on each worksheet is an
array of data. I'm creating a summary worksheet to sum all of the other
worksheets. The problem is that all of the worksheets aren't aligned....the
data to be added is all in column "E" but on its on a different line on every
sheet.
Each of the data lines does have a common identifier so that I can use the
V-lookup formula to find the data to be added, but with so many sheets, it
would be a very, very long formula.
Question, if I make all of the data arrays the same size, can I use the
Vlookup formula across multiple worksheets....if "yes", how?
If not Vlookup, is there another means to do it?
Thanks
array of data. I'm creating a summary worksheet to sum all of the other
worksheets. The problem is that all of the worksheets aren't aligned....the
data to be added is all in column "E" but on its on a different line on every
sheet.
Each of the data lines does have a common identifier so that I can use the
V-lookup formula to find the data to be added, but with so many sheets, it
would be a very, very long formula.
Question, if I make all of the data arrays the same size, can I use the
Vlookup formula across multiple worksheets....if "yes", how?
If not Vlookup, is there another means to do it?
Thanks