How to Copy and Paste only new rows

  • Thread starter Thread starter johnmanc
  • Start date Start date
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.
 
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
 
Could you explain what you mean by "unless it is new" here? New to
whom/what?

/ Tyla /
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to apply a function to an entire column 1
Excel 2007 - copying filtered data to another workbook 1
Copy and paste 3
How do I copy and paste only the sub-total from a list 3
Copy Paste issue 3
How to migrate Gmail to Office 365? 2
Copying and inserting lines 6
want to track time while paste value in multiple column of same roe 1

Back
Top