Transferring multiple rows o data to another sheet, but only put the header row in 1 time.

[zookeepertx]

Hello!

I have a sheet with 33 columns of data that is divided up by Order Number. Each Order Number section has the exact same header row. I've made a macro that transfers all the data to a second sheet, but my current code also tranfers the header row on the second sheet above each order number section. I only need the header row on the second sheet one time.

Is there a way to, before the main part of the macro runs, have it enter the header row titles across row 3 on the second sheet in one shot without having to specify each of the 33 columns?

Thanks!

Jenny

[xladept]

Something like this:

Please Login or Register  to view this content.

[zookeepertx]

Oh dear - I'm sorry! I completely mis-stated my problem!

The words in the header row consist of words picked out from different places on sheet 1. I can either copy/paste them individually or just have the macro enter the header title into each cell. But, in either case I'd have to specify each cell across the 33 columns individually:
Range("Sheet2!A" & r).Value = "Order"
Range("Sheet2!B" & r).Value = "Ship to"
etc, etc.

Can I do that without having to specify every, single cell (A & r), (B & r), etc all the way across the 33 columns?

I TOTALLY don't understand Arrays, but could that help?

[xladept]

The headers for the columns are in a different order on the "two" sheets?

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[zookeepertx]

The headers for the columns are in a different order on the "two" sheets?

Yes; this is quite possibly the STUPIDEST report I've ever seen in my life!!

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Okay, here's a very shortened version, just showing 1 order. (The colors on the "desired results" sheet are not needed. I just put them there as a visual aid for myself. I need all the help I can get, LOL!). You'll notice that all the raw data is in Column A. This has been a trial because there are NO tabs in between data "blocks" - just spaces - so no way to do text-to-columns. Even going with spaces, they're so inconsistent, that it still comes out all kinds of wrong!
As I said: stupidest report EVER!

[xladept]

For the headers only:

Please Login or Register  to view this content.

*You only wanted code for the headers - right!

[zookeepertx]

*You only wanted code for the headers - right!

Yes, just the headers. The rest of it is REALLY a mess, but I've got it at least partly cooperating. I like to at least TRY to get things figured out before asking for help; that way I don't feel quite as dumb, LOL! But I spent the better part of yesterday trying to get the header situation solved so I gave up.

This works perfectly!! Thank you so much!

Have a great day!

Jenny

[xladept]

You're welcome and thanks for the rep!