Autofill macro or anythin tht could help.....

Closed
Report
-
 Ray911 -
Hello,

I have a XLSX file of my products list, there are 3959 parts total. They go like this

Column A
07 11 9 900 250
07 11 9 900 673
07 11 9 901 294
07 11 9 901 438.. so on

What i want to do is leave the existing as they are however add 3 more rows for each product like so..

07 11 9 900 250
07 11 9 900 250-E
07 11 9 900 250-G
07 11 9 900 250-T
07 11 9 900 673
07 11 9 900 673-E
07 11 9 900 673-G
07 11 9 900 673-T
07 11 9 901 294
07 11 9 901 294-E
07 11 9 901 294-G
07 11 9 901 294-T.. so o

TO import them into Peachtree, However i m not able to use autofill as i m not familiar with macros or anything advanced in excel.

So tell me if theres a formula or a autofill macro or anything tht can solve this.

So the main goal is to add a letters after every part number thrice (E, G & T)

Really appreciate any help,
Plz post if u need the files .

FYI: I m using Excel 2007 and have to make this edit in xlsx file and later copy it into a CSV file to be imported into Peachtree

2 replies

send me your file and i'll send you the result with formula and description: nesterenko_79@mail.ru
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Attached and sent.