Copying Cells

L

Lee

I have a summary sheet I have created where I wnat to capture data from a
number of worksheets that are identical in terms of their layout but will
ahve different values in some of their cells.

Is there a quick way to create this summary sheet. I have tried pasting in
values for several rows and then dragging down in a column which seems to
increment the cell being looked at but I need it to keep the same cell and
increment the worksheet.

Thanks,
 
M

Marcelo

hi Lee,

try on menu DATA and options Consolidation, I am not sure about the names on
the menus, because I am using an excel in Brazilian Portuguese.

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Lee" escreveu:
 

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

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Summarise data from several worksheets in a workbook 2
modify all formula references in multiple cells 3
Match Copy/Paste Macro almost there 0
Lookup based on list selection in cell 0
Macro will copy formula instead of value 6
Copy Cells from multiple Worksheets in same workbook. 2
Formula for transferring data in rows to columns on two different Worksheets 1

Top