Pulling Results into another sheet

[rickschepp]

I am trying to pull together information from roughly 100 sheets into one sheet. I have 6 cells (all in one column) that I am trying to pull together. After pulling them into the other sheet, I need them to be in a row as opposed to a column. Is there some sort of a formula or something that can set so that i can just tell the row what sheet to reference for each sheet and it can find the data I need? The information I am pulling is always in the same row, but not column.

Thanks!

[Bryan Hessey]

I am trying to pull together information from roughly 100 sheets into one sheet. I have 6 cells (all in one column) that I am trying to pull together. After pulling them into the other sheet, I need them to be in a row as opposed to a column. Is there some sort of a formula or something that can set so that i can just tell the row what sheet to reference for each sheet and it can find the data I need? The information I am pulling is always in the same row, but not column.

Thanks!

Hi,

it is not clear what you are asking for, you can 'make up' an address by haveing parts of the address in cells, thus with Sheet2 in A10, A in A11 and 1 in A12 you can use

=INDIRECT(A10&"!"&A11&A12)

to fetch A1 from Sheet2, or with 2 in A10 use

=INDIRECT("Sheet"&A10&"!"&A11&A12)

however,

you say that you want to transpose the data, so a Macro with Copy and Paste Special = Transpose would be more useful, especially if 100+ Sheets are involved.
You can Tools, Macro, Record New Macro and do the copy-paste etc, this will give a good idea as to what code would be involved, and then add a Loop to that for each sheet excluding this one etc.

Let me know how you go.
---