| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
move from sheet1 to sheet2 if criteria is met
I need VBA code that will move a row of data from Sheet1 to Sheet2 based on a
match to criteria. The criteria cell currently has the following formula in it: =IF(P11=1000,500,P11) If this formula is true the procedure must remove the row from Sheet1 and plac it in the next available row on Sheet2. The procedure must loop until there is no more data matching the criteria on sheet1. I really need this help ASAP. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatic populate Sheet2 with data from Sheet1 based on criteria. | Excel Discussion (Misc queries) | |||
| how can i move from from sheet1 to sheet2 in the xl without mouse | Excel Worksheet Functions | |||
| Move Records from Sheet1 to Sheet2 | Excel Programming | |||
| copy data from sheet1 based on criteria in sheet2 to sheet3 | Excel Programming | |||
| multiple search criteria to find and copy from sheet1 and paste into sheet2 | Excel Programming | |||
Threaded Mode
