Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 .. .. .. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 .. .. .. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
error when running cut & paste macro | Excel Worksheet Functions | |||
Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Highlight Range - wrong macro, please edit. | Excel Worksheet Functions | |||
Help! Heeeelp! can I copy an excel macro to another computer | Excel Discussion (Misc queries) |