Closed

EXCEL MACRO NEEDED - EASY

PLEASE DOWNLOAD THE EXCELL FILE, IT IS ALOT EASIER TO SEE WHAT WE NEED TO HAVE DONE. THE COLUMNS RUN TOGETHER IN THIS TEXT FORMAT!!!! YOU CAN WORK IT HAS ALL OF THIS INFORMATION.

We need a macro that will convert an entire spread sheet to reference a manufactures part number not the “Product Page ID#”.

We have over 20,000 SKU numbers.

I am not a programer, but basically it would say:

Find 15071 and convert to MFG#: 110-37 in the Accessories Column.

Or Look at the acessories column, find the first number, go to Prod Page ID#, find the same number, look at the and convert it to the MFG PN.

Our Accessories list references a Prod Page ID#, not the Manufactures PN.

So we need to convert the products accessories to the manufactures actual product number.

On line 3 MFG# 110-37 is a master product and the accessories that work with it are found on line 15 and 16. The problem is our file references the Page ID, not the MFG PN. You will see in the far column that we have converted the “Accessories” column to reference the Actual MFG PN.

Here is how our file looks:

1 Prod Page ID# MFG PN Mfg Accessories – this does not work We need to make the “Accessories list look like this:

2

3 15071 110-37 MFG Name 17077|25007 117-19|117-09

4 25196 110-80 MFG Name 16296|25202|25211 117-41|123-26|116-25

5 25311 110-87 MFG Name 15462|31995 106-37|132-00

6 25197 110-79 MFG Name 17077|15462|31995 117-19|106-37|132-00

7 25198 116-15 MFG Name 25207|28004|28005 123-27|119-53|119-34

8 25200 110-81 MFG Name 30891|28116|28006 119-86|119-51|119-01

9 25199 110-69 MFG Name 15462|31995 106-37|132-00

10 16295 117-46 MFG Name 17077|15462|31995 117-19|106-37|132-00

11 25009 117-10 MFG Name 17077|15462|31995 117-19|106-37|132-00

12 16297 117-43 MFG Name 14620|25010|25210| 117-42|117-05|116-19

13 25203 116-23 MFG Name 17077|15462|31995|31539 117-19|106-37|132-00|B60-20-LOW-BL

14

15 17077 117-19 MFG Name

16 25007 117-09 MFG Name

17 16296 117-41 MFG Name

18 25202 123-26 MFG Name

19 25211 116-25 MFG Name

20 25212 116-21 MFG Name

21 25208 116-24 MFG Name

22 25210 116-19 MFG Name

23 25010 117-05 MFG Name

24 16420 117-42 MFG Name

25 25207 123-27 MFG Name

26 28004 119-53 MFG Name

27 28005 119-34 MFG Name

28 30891 119-86 MFG Name

29 28116 119-51 MFG Name

30 28006 119-01 MFG Name

31 30434 121-03 MFG Name

32 30433 121-06 MFG Name

33 30435 121-04 MFG Name

34 31539 B60-20-LOW-BL MFG Name

35 31995 132-00 MFG Name

36 15462 106-37 MFG Name

Skills: Data Entry, Data Processing, Engineering, Excel, Website Design

See more: work excell, we excell, we excel, text easy, prod design, need programer find, mfg website, master find, make spread sheet, find master, far part, easy problem, easy make website, 123 website design, line processing, master excel, website programer , sku, run sheet, programer website, programer needed, programer find, macro, macro excel, line sheet

About the Employer:
( 1 review ) edmond, United States

Project ID: #220427

36 freelancers are bidding on average $43 for this job

NishantBamb

Hello, please refer your PMB. Thank you.

$100 USD in 1 day
(151 Reviews)
7.1
svet63

VBA developer since 1997. This is an easy one. Regards, Svet.

$30 USD in 1 day
(64 Reviews)
6.6
MAnkita

Hello,Please refer your [url removed, login to view] you.

$80 USD in 2 days
(114 Reviews)
6.5
best4best

Please see PMB.

$30 USD in 1 day
(133 Reviews)
5.9
wsh2

Greetings Oklahoma form the "Keystone State" of Pennsylvania.. {smile} Your instructions are clear.. lets begin! Hello my name is Bill.. I am a MsExcel, MsAccess, [url removed, login to view], VB6, VBA, VBScript, SQL, and Windows More

$89.95 USD in 1 day
(21 Reviews)
5.4
hiratariq

Please see PM

$70 USD in 2 days
(10 Reviews)
4.3
johnsinit

Dear okfarris! I am an experienced VB and VBA programmer and would be happy to work for you. Please, check PMB. Sincerely yours, John.

$30 USD in 2 days
(20 Reviews)
4.2
ramvinod

I can do this project for you

$75 USD in 1 day
(1 Review)
3.3
tamilsweet

Check PM for details... :-)

$30 USD in 0 days
(6 Reviews)
3.0
Progmatics

Piece of cake! Already done. See PM.

$30 USD in 0 days
(2 Reviews)
2.6
kmohan1962

Hello; Can u brief the logic behind to build the lists. REgards.

$30 USD in 1 day
(5 Reviews)
1.8
carlestops

Hello hours from now I'll give you 1) A sheet where you process data 2) a file where your data are automatically saved and formatted. see PM. Your project is as good as done.

$30 USD in 0 days
(0 Reviews)
0.0
peddy

I am very interested, and ready to start. I will do my best. Thanks.

$30 USD in 2 days
(0 Reviews)
0.0
MaiXinh

Pls check my Pm

$50 USD in 0 days
(0 Reviews)
0.0
nareshvuppala

I can do this work for you.

$40 USD in 1 day
(0 Reviews)
0.0
alifiyanto

Let's begin to work and complete this job. Thanks

$30 USD in 1 day
(0 Reviews)
0.0
Vasssya

Project is ready.

$30 USD in 0 days
(0 Reviews)
0.0
jratna2

I have already built a macro for your sample file and it works. But I need to make some changes for your full file. I am asking for 3 days to iron out the bugs that may creep in.

$40 USD in 3 days
(0 Reviews)
0.0
segeyplus

Hello. I could do the macros. Look at example I apply. Almost the same task. __________ )) I have sent you solved task in PM.

$50 USD in 1 day
(0 Reviews)
0.0
lucek

I'll write easy to understand macro with comments

$30 USD in 1 day
(0 Reviews)
0.0