Macro to Pull & Re-Format data in excel.

[Kenichi]

I have a LOT of data that needs pulled from one format to another.

This is an excel file with a data sample and a sample result of what I want.

I understand this is a volunteer forum but I'm willing to pay/tip for a working macro.

The sample .xls is here: http://www.businessbees.com/files/XYZcoInstructions.xls

Thanks in advance , it's a lot of values so I've no idea where to begin.

 

[Trevor G]

Looking at the workbook it seems that you want to take data from one sheet and then create a master list, is that correct? if so then look at this code. I am assuming the master will be in the same book. I have made an additional sheet to copy the data to first.

Sub copyrange()
Application.ScreenUpdating = False
With Sheets("Sample Result Take a copy") 'The following is a small sample
.Range("A2") = Sheets("Sample Data").Range("B6")
.Range("B2") = Sheets("Sample Data").Range("B7")
.Range("C2") = Sheets("Sample Data").Range("B8")
End With
Sheets("Sample Result Take a copy").Activate
Rows(2).EntireRow.Copy
Sheets("Sample result").Activate
Range("A1").Select
Do Until ActiveCell.Value = ""
ActiveCell.Offset(1, 0).Select
Loop
ActiveCell.PasteSpecial xlPasteValues
Sheets("Sample Result Take a copy").Activate
Rows(2).EntireRow.Delete

ActiveWorkbook.Save
Application.ScreenUpdating = True
MsgBox "Data Transfered OK", vbInformation, "Excel Sample"
End Sub