VBA Automatically Move rows to next sheet

[thameem127]

Dears,

How can I move rows automatically which meet certain criteria

For example : cell A1 contains value >1500 it automatically move to sheet 2 cell a1. Any body can help me please

[rvasquez]

Hello thameem127,

I have attached a workbook that I believe achieves what you have requested. Currently it is set up so that anytime you change your selection in sheet1, it looks through the cells in column A and finds any that have values over 1500 and then moves it to sheet2 and deletes it from sheet1. Please let me know if you have any questions.

Thanks,

RVASQUEZ

[thameem127]

Thanks a lot my dear friend.

[thameem127]

I need this same for row and also with text criteria

example
Date product name quantity recieved location
08.04.12 product1 50 store 1
09.04.12 product1 89 store 2

first data to be moved sheet store 1 and 2nd data to be moved sheet store2

Help me please.