Copy row data to ws based on Date in cell

**Code Flunkie** · 12-04-2009, 02:46 PM

Hi, i'm trying to automate some repetive tasks on a list I use at work and update frequently. I have a list of products and their upc numbers on one sheet and on another sheet i keep a list of the last 100 changes made to the master list. each item has it's info on only 1 row, from A to N. the changes are listed by row from newest to oldest on the second sheet. right now when i make a change on the master sheet, i have to (on the second sheet) I copy all the data from row 2 on down 1 row, then I copy and paste the values of the item information of that row from A:N on the first sheet to the second sheet in row 2 in the place i just made.

On the first sheet in column P, i have a worksheet_change macro that puts the current date when a change is made to the info in that row. the relevant part of the macro is below

   .NumberFormat = "mm/dd/yyyy"
                        .Value = Date

what i'm looking for is
1. the macro is executed before save
2. because I sometimes make multiple changes in a day the macro has to check to see if the data is already there for that day. if the data was changed another day it should make a new entry
3. keep the data newest to oldest (changes on the same day can be in whatever order)
4. the macro should delete row 102+ on the second sheet so only 100 changes are kept

ps. I tried to include the file but there seems to be a database error, so i'll try again later.

Chris

**mewingkitty** · 12-04-2009, 02:59 PM

I just finished building something that sounds similar for my own use at work. If you have any luck getting that uploaded I'm sure we can get you set up.

mew!