Collating Data from Many Worksheets Within a Workbook

  • Thread starter Confused_in_Houston
  • Start date
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
 
J

joel

Formulas can be used if you are returning on row/column of data for each
formula you write. but formulas are slow and if you are returning
differetn amount of data each time the workbook is updated.

A better method would be to write a vba macro to perform this task.
People would aruge the fact when macro should be used or formulas should
be used. But if you are returning a LARGE amount of data the formula
tend to slow down a workbook considerably.

Provide more information on the organization of the workbooks and data
so you can get the correct solution.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top