Search for Cell Value N highlight in another worksheet

Hi everyone, (Thanks For Reading this Thread)

1. I am pretty new to this excel programming like to find out few things.

2. How do I (In VBA) search for a value in a column (column at times are merge. Extract out the value & compare it with another worksheets.

3. Upon found similiar value, highlight the whole column

Regards, & God Bless

Hi
It is possible to search and highlight in VBA. But you should give us specific examples since the codes are to be customized.
Ravi

Hi Ravi,

1. Thanks for reading & replying to my thread, appreciate it.

2. In a workbook I have three worksheets namely,
a) Old Format
b) Master Lists
c) New Format


3. Objective: Because currently my comp is changing the format of its parts lists(old format) into New format

4. Master Lists worksheets conatins all parts details, what I need is search through individual parts no (column 5 I think)
through old Format and find it in Master Lists worksheet.

5. Once located within Master Format> Part No, copy the whole row and do a highlight. so that I can do a manual select
and paste into New Format Worksheet

6. Is a bit challenging since that In old format I have more than 20 parts lists, and I have do a search & find for 20++ times.

7. If you think thats easy, hang on. 1 piece of Old format is 1 model, and guess what? My company carrying in thousands of model.

8. Well, Guess I gotta learn excel programming for this task though.

9. By the way, do you happen to have any good recommendation of reference books for Excel 2000 Programming ?

Thanks & God Bless



Regards & God Bless

Hi
you can learn VBA at your leisure. let me give you some "aspirin" for your "headache". Give me more details of what you search for and what is your new format etc. preferably upload a zipped file of your excel.
Ravi shankar

Hi Ravish,

1. Appreciate you read & reply to my mails so quickly.

2. Even go to the extend of offer to look at my codes.

3. However sorry to dissapoint you that, I am going against company policy by giving away those sensative contain file.

4. See if I can work it out.

5. By the way, do you have any good reference book to recommend on Excel 2000 Programming in VBA ?

Thanks & God Bless