How to Copy and Paste only new rows

J

johnmanc

I have a spreadsheet with various test results. I ask the user to copy
all (only option) the records once a day and paste into these into
spreadsheet from application. What I would like is for when this
occurs a macro that deletes all data unless it is new into another
spreadsheet. Then I will export only new data to a sql table. Any help
is greatly appreciated.
 
J

Joel

What you want the person to do is to copy all the data into a new temporary
worksheet. Then compare the new and the old worksheet and put only new data
into 3rd worksheet. the macro can also do any clean-up that is necessary.

You din't describe in enough details how to tell new data from old data so a
comparison can be made.

A macro can be writen to do the comparison
 
T

Tyla

Could you explain what you mean by "unless it is new" here? New to
whom/what?

/ Tyla /
 
Top