Need help making a macro to copy range of values based on cell values.

Hey,

I'm not the greatest with vba in excel so I could use some help because I can't figure out the best approach to accomplish this task

So I have a file that was imported from a RTF file. I need to go through the first column of the data and separate it into two columns. Right now the data looks like this:

CustomerID

123456

Inv No
123485
1284558
1385475
2437585

CustomerID

85676849

and so on for a couple thousand lines.


I need to create a macro that copies the Customer Id into one field and then their invoice numbers into the other field. Any help or direction would be greatly appreciated.

Thanks,
Zach

Hi Zach

could u plz provide actual workbook file.

Nice post, very helpul

Naveed,

Thanks for the reply. I have attached the first column of the workbook file. It is in the exact format of the original document. I need to separate the data so that Customer Id is in one Column and then the Inv No is in the next column.


Thanks