Excel Help... Thanks

[MikeMike]

Hey,

I am trying to take data from one excel sheet, and place that data, in a new sheet.

The new sheet, does NOT have the same headers, nor the same order of data columns as the sheet I am taking the data from.

I am wondering how to accomplish this without manually typing in the 350 rows of data...

IE:
Sheet 1 columns which have data
SKU, Order, Name, Date Shipped

Sheet 2 columns, which have no data
Order, Name, Date Shipped, SKU

Now, not every column in sheet 1 needs to be transferred to sheet 2.

Thanks in advance
😀

 

[Binky]

Is there ANY data on the second sheet? If not, you can just use simple formulas to copy the data down.

If there is some data in the new sheet, you could pull selected data with an index/match function. You need something to tie the data together on the two sheets and you didn't give enough info.

i.e. if you could link the order numbers on each sheet, you could pull any data you need from the other sheet based on the order number.

 

[mb]

Either you're leaving out some details or you are over thinking this.. I don't see why you can't you just rearrange sheet 1 and add any additional columns as needed. Or just copy each column over for the matching headers?

 

[MikeMike]

Either you're leaving out some details or you are over thinking this.. I don't see why you can't you just rearrange sheet 1 and add any additional columns as needed. Or just copy each column over for the matching headers?

there is data on the first sheet that i do not need on the second, aka there are more serials on sheet 1, than i have order numbers for, so not all serials need to transfer over...

and yes, sheet 2 has no data, except for the headers

 

[Binky]

You can just link the data with formulas (e.g. =Sheet2!A2) and copy them down the sheet. To break the links, just copy the entire column or the entire sheet, select Paste Special-Values.

=Sheet2!A2
=Sheet2!A3
=Sheet2!A4
etc.

You should do this for all rows, including those that you want to get rid of. Once you do this, you can delete any row that has a blank serial cell (noted in your last post) with a macro. There may be other ways to do this too, but this should work (run this macro while you have the serial cell selected-make a backup of the sheet first):

Sub delete_rows_if_cell_blank()

Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual

Dim m As Variant
For R = 1 To 400
    m = ActiveCell.value
    If m = 0 Then
        ActiveCell.EntireRow.Delete
    End If

If m <> "" Then ActiveCell.Offset(1, 0).Activate

Next R

EndMacro:

Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic

End Sub