Quick Excel Macro Or Application

Closed

Description

I need a small excel macro or application. I have 2 excel files. First file contain list of products, sku codes (Column "Q") and categories names (Column "R"). Second file contains list of categories and there ids associated. There are two tasks involved.

1. I want macro to read the categories names from first file find it on second file check its id and replace the category names in first file with its id.

2. After first task is completed now it needs to work on first file only. The first file will now have list of ids in different rows. I want the macro/script to put ids in its master row for each product in front of its sku separated with comma and delete the rows which don't have sku code's.

To understand better check the attached sample files and also file with sample results what exactly i need.

First Task in Row no 8 in first file is completed while second task is remaining. This is just to show you as sample what i need in second task. Let me explain. In second task you can see rows no 9,10,11 contains the ids as first task is already completed. So i want the macro to take ids from row 9,10,11 and put them in there master row no 8 separated with comma just like i did in other sample rows.

Let me know if u have any questions.

Skills:

See more: q find, find it application, what is macro in excel, master excel, quick excel, macro script file, excel macro row, excel delete row, check excel files, replace excel macro, excel products categories, excel macro find replace row, replace excel row, sku list excel, excel application replace, list category products, codes excel, small excel, want master excel, macro script excel file, application list excel, excel product list, delete rows excel macro, excel delete, task list application

Project ID: #2790347

Awarded to:

tawakalgeek

See private message.

$10 USD in 1 day
(102 Reviews)
0.5

7 freelancers are bidding on average $9 for this job

darkknight2012

See private message.

$10 USD in 1 day
(29 Reviews)
0.0
waseemabs1

See private message.

$8 USD in 1 day
(0 Reviews)
0.0
azrajobs

See private message.

$10 USD in 1 day
(63 Reviews)
0.0
masanisreekar

See private message.

$10 USD in 1 day
(3 Reviews)
0.0
ashiva1976

See private message.

$5 USD in 1 day
(6 Reviews)
0.0
SHhadun

See private message.

$10 USD in 1 day
(25 Reviews)
0.0