Selecting, copy and pasting cells

Selecting, coping cell data from multiple sheets and pasting them in another sheet in one vertical row .. How do I do that?

Originally Posted by xladept

Hi patigonia,

Where is the data, where are the sheets - are they in the same book?

the data is in the same book

Originally Posted by xladept

Hi patigonia,

If they're always in the same place, you could just link them.

they are not in the same place.. so now what?

test.xlsx

Originally Posted by Richard Buttrey

Hi,

I think we need to know a little more. e.g.
Where are the cells to be copied?
Are they always in the same position on each sheet?
Are all worksheets to be processed?

Upload an example workbook and manually enter the results you want to see.

Regards

I uploaded a file. It is very simple to demo my problem. I would just want two cell values demonstrated in sheet2 and sheet3 to be displayed on sheet 1 in the same row.

They are not in the same position on different sheets. Worksheets should have the capability to be processed, if possible

thanks

Originally Posted by Richard Buttrey

Hi,

You haven't said whether all sheets in the workbook should be processed. More importantly your original post mentioned that the result should appear in one vertical row. This contradicts the example you attached.

Please clarify

One further Q. Is there only one cell on each sheet to be copied?

One has to ask the question why is the data captured in many sheets. What is the process that populates these sheets. Is it not possible to capture all data in one sheet from the start?

As you probable gather i am not savy with excel/stats etc I am going to ask a rudimentary Q
Please define "processed"

In terms of "vertical row" I meant to say horizontal row. The example is correct.
THere is only 1 cell in each sheet to be copied

In answer to "What is the process that populates these sheets. " Well this is a long story. I