Closed

Excel Macro-List of Parts and Mark on another worksheet

I have a list of product #'s (Column A) on a worksheet 1. On Worksheet 2 is a large list of products of many column, but Column A is the product #.

I need:

1) On worksheet 2(large list) create a new column. ie. Insert before column A, thus product #'s is now in column B

2) Take the 1st product # from worksheet 1 A1 and loop thru column B(worksheet 2)

If found put the word "DELETE" in Column A of worksheet 2.

Go back to worksheet 1 and put in column B for that product the word "FOUND" else put the word "NOT FOUND"

3) Keep looping thru the product list on worksheet 1 until end.

4) When end,

Sort Worksheet 1 by column B("FOUND OR NOT FOUND") then by column A(product #)

Filter worksheet 2(DELETE) and sort by Product Number

The only SETUP I can think of is to be able to choose worksheet 2(as the name of this worksheet changes quite often)

That should do it, pretty straight forward I think.

Skills: Excel, Visual Basic

See more: name parts mark, parts list macro excel, excel mark found column, excel macro parts, parts now, parts list excel macro, excel mark, sort excel, mark, create excel worksheet, another back, excel macro sort, sort macro, insert macro excel, excel filter list, excel number word, word macro basic, macro else excel, number word excel, sort list, macro loop list, macro excel create word, loop excel visual basic, excel create list, excel create macro

About the Employer:
( 36 reviews ) Riverside, United States

Project ID: #2563905

34 freelancers are bidding on average $50 for this job

jaylancer43

Greetings....!! Please check your PMB...!!!

$30 USD in 0 days
(487 Reviews)
8.0
svet63

Yep, it's pretty straightforward, indeed. Can do. Regards, Svet.

$50 USD in 1 day
(80 Reviews)
6.7
nagybatonyi

Such jobs are my daily practice. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet to More

$50 USD in 1 day
(61 Reviews)
5.7
RajHeartbeat

hire me!!..please provide me those two spreadsheets..so we can start..Regards..Raj..!

$80 USD in 999 days
(47 Reviews)
5.7
vserv

Not a problem. I specialize in Excel work. Please see your messages. Thanks

$30 USD in 1 day
(64 Reviews)
5.9
srikartiram

Plz see PMB

$30 USD in 1 day
(103 Reviews)
5.8
Krusche

Our team of 3 VBA developers possesses the key skills needed for this project and we can start right now. Please check your PMB.

$45 USD in 1 day
(30 Reviews)
5.6
sonarkaushik

Sir, I can do the project. Refer PMB. with regards

$38 USD in 2 days
(42 Reviews)
5.6
muzammil21

we do not offer package we offer Only guaranteed results..100% quality work within time limit and ...Read more in PMB

$230 USD in 7 days
(21 Reviews)
5.4
Pichart

I am an excel developer. I am expert in Excel both excel standard and Vba coding. I work with excel more than 10 years. I love to work with excel, always comfortable with excel. I am interested in your project and have More

$35 USD in 1 day
(37 Reviews)
5.3
rajanlengde

I can do it well. I think it will faster we first sort the sheet for column then we need not required to check all rows. else it will be time consuming for you.

$30 USD in 1 day
(29 Reviews)
5.2
Nhcuong

Hi, I can do it! I'm programmer for years and very familiar with VBA for excel automation. You can considered it is done. What is your excel version? Looking forwards to work with you, Cuong NH

$30 USD in 1 day
(30 Reviews)
4.9
KellogITSolution

Hi can do this. Just waiting to hear from you soon. Thanks

$30 USD in 1 day
(18 Reviews)
4.5
HosElectro

Hi , experiences visual basic and excel macros for more than 7 years i can help you please check my PMB

$50 USD in 2 days
(15 Reviews)
4.6
microk

Expert Here. Please check PM..

$30 USD in 1 day
(30 Reviews)
4.4
vnb400sl

i can develop a VBA script for your requirements.

$30 USD in 2 days
(30 Reviews)
4.5
Engineer85

Hi I am an Engineer and Excel professional and can do this task for you. Thanks

$30 USD in 0 days
(9 Reviews)
4.1
vikashgadia

We r macro expert having experience over 13 years

$30 USD in 0 days
(15 Reviews)
3.8
FLtowhid

Please see my PM

$30 USD in 2 days
(4 Reviews)
3.8
AdamT82

Dear cc4digital, In response to your job, I am pleased to inform you, that I finished the project, based on information which you provided. I can deliver it as soon as possible. Of course, if you would like, I can show More

$30 USD in 1 day
(1 Review)
2.3