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 2942 users have said thank you to us this month

Attached and sent.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!