View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gavin[_2_] Gavin[_2_] is offline
external usenet poster
 
Posts: 6
Default How do I combine data from multiple worksheets into one masterlis

On Aug 31, 3:37*pm, KW wrote:
Hi~

I'm trying to set up a grid template that will take a few columns of data
from each of several pages within a workbook and automatically populate it
into a master list on another worksheet. *I know how to do this for copying
from one worksheet to another, but am unsure of how to copy from multiple
sheets into one without the data pasting over the previous page's list. *

I'm not sure how best to describe this, so let me know if there are questions.

Thanks!!
KW


Do you want to just set a cell in the master sheet equal to a cell
with data in a seperate sheet? I am assuming you manually update
these other sheets, and you only want a few cells to roll forward into
the mastersheets. Is this what youare lookin gfor?