paste to summary sheet based on row number

**fabrecass** · 02-12-2013, 07:14 AM

Hi guys,

i need a macro that copies rows 10 and 12 and transposes them onto a "summary" sheet, then repeats for next worksheet.

i know this is simple but i can't get it to work properly.

can anyone help?

**arlu1201** · 02-12-2013, 07:21 AM

Do you have a sample that you can upload?

**fabrecass** · 02-12-2013, 07:28 AM

please see example file

**arlu1201** · 02-12-2013, 07:54 AM

Can you explain how you want the transpose to be performed? Should i take the data from the 1st 2 sheets? The 1st sheet has 2 columns of data while the 2nd one has 4.

**Winon** · 02-12-2013, 08:01 AM

Hi fabrecass,

The WorkBook you have uploaded is exactly the same as the one in which you wanted to Copy Sheets From column B to the Summary Sheet. And I have just sent you the solution a little while ago http://www.excelforum.com/excel-prog...-new-post.html

I'm afraid I don't quite understand your requirement now:

i need a macro that copies rows 10 and 12 and transposes them onto a "summary" sheet, then repeats for next worksheet.

Where on the Summary Sheet do you want it copied to, and how would you like it to appear?

**fabrecass** · 02-12-2013, 08:02 AM

Hi arlu,

sorry for not being clear.

i need rows 9 and 11 (not 10 and 12 as originally stated!) copied and pasted (transposed) onto the summary sheet.

ideally without the first column? does this make sense?

I've amended the example to show the result i'm after.

**fabrecass** · 02-12-2013, 10:50 AM

Hi Winon,

your macro worked perfectly for the requirements I gave you! thank you!

These are separate requirements i need to perform on a very similar workbook! except this one has over 200 worksheets.

hope this makes sense?