Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find, Cut, Paste and Delete
I am looking for VBA code to look in the “master” sheet and find all the “A”
s in a column. Once it finds an “A”. It copies the row and paste it into another sheet “NPS”. Go back to master delete that row and move on to the next Repeating until the column is exhausted of all the A’s. Column is always Q. I tried this with an autofilter and messed up on the delete phase. New to complex macros and any help would be appreciated. -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cant find & delete invalid formulas or links | Excel Discussion (Misc queries) | |||
Delete graphics copied from a Web page | Excel Discussion (Misc queries) | |||
link data to new workbook | Excel Discussion (Misc queries) | |||
I want to delete duplicate rows of similar info and use the lates. | Excel Discussion (Misc queries) | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) |