Copy formula for ranges from diff sheets

  • Thread starter Thread starter Bernie
  • Start date Start date
B

Bernie

Unfortunatley then i have to go to every sheet, copy and paste special
(transpose)

What I need is some sort of formula that will copy the same range fro
_all_sheets_ and then paste special (transpose) on to the referenc
sheet.

?
 
when it is pasted on the reference sheet, is it all pasted in the sam
row, or each sheet's data is pasted on the next row
 
You must log in or register to reply here.

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

Macro to run on hidden sheet 4
Copying data to the next blank row 0
How to copy from sheet1 then paste special transpose to sheet2,3,4 1
Formula for transposing Row Values to Col Values 2
excel transpose and references to cells in other sheets 2
How to transpose data (Row to column) without losing the cell link 3
Macro to copy/paste from one workbook to another 8
Relative Range Selection & Paste 2

Back
Top