Macro HEEEELP
Hi I am comparing two lists in excel. The first list contains part
numbers and it is my list. The next list contains part numbers and it is the customer's list. I have compared both lists to determine what the customer has and what I have. If the customer has it and I have it, then the formular returns "yes" if not then "no." I would like to create a macro that cuts and pastes the "no's" into a new column. The Data is organized as follows Customer Data (cells 2 thru cells 584) Column A Part No. 102634 .. .. .. ------------- My Data (cells 2 thru cells 953) Column D Part No. 102635 .. .. .. |
Macro HEEEELP
try it
http://www.j-walk.com/ss/excel/usertips/tip073.htm hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Ben" escreveu: Hi I am comparing two lists in excel. The first list contains part numbers and it is my list. The next list contains part numbers and it is the customer's list. I have compared both lists to determine what the customer has and what I have. If the customer has it and I have it, then the formular returns "yes" if not then "no." I would like to create a macro that cuts and pastes the "no's" into a new column. The Data is organized as follows Customer Data (cells 2 thru cells 584) Column A Part No. 102634 .. .. .. ------------- My Data (cells 2 thru cells 953) Column D Part No. 102635 .. .. .. |
All times are GMT +1. The time now is 01:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com