macro help. archiving from 1 sheet to another when date is entered

[djtoyo]

i am having trouble finding a solution to archiving. i have a excel spreadsheet with columns that have product information and when it was rented out and returned. the list doesn't change just who rents it out and date out and in. i was wondering if there was a way to archive each row when a date is entered into column "I" that will automatically send that row with all rental info to another spreadsheet. so every time someone returns a product then i can input a date it goes to another list and i can delete the row. to keep track of all the people who have rented from us.

thanks

 

[DILIPandey]

Hi djtoyo,

Yes, it is possible using vba (macro), would be helpful if you post your sample data to enable me to understand your data layout. Thanks.


Regards,
DILIPandey

 

[djtoyo]

do have some color coding for dates. i would like when date is entered in I that it will send to possibly a new spreadsheet then i can delete that row until it's used again.

 

[DILIPandey]

i would like when date is entered in I that it will send to possibly a new spreadsheet then i can delete that row until it's used again.

Okay.. share the layout as I need to know where is that date and row.


Regards,
DILIPandey