C
Confused_in_Houston
I have a workbook that has about 2 worksheets in it. I need to pull all the
data from each column, one column at a time, into a "master" worksheet. I
really don't want to open the worksheet, copy the column of data, go to the
master worksheet, then paste... over and over again.
Is there an expression or formula that I can write that would allow me to
pull the data from the multiple sheets into the master sheet? I understand
that even with a formula to do the extraction, I would most likely need a
formula for each worksheet. That's okay. I'd rather write 20 formulae than
cut and paste from 20 sheets.
Thanks
data from each column, one column at a time, into a "master" worksheet. I
really don't want to open the worksheet, copy the column of data, go to the
master worksheet, then paste... over and over again.
Is there an expression or formula that I can write that would allow me to
pull the data from the multiple sheets into the master sheet? I understand
that even with a formula to do the extraction, I would most likely need a
formula for each worksheet. That's okay. I'd rather write 20 formulae than
cut and paste from 20 sheets.
Thanks