do not copy data to another sheet if exists

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

I am trying to copy data from sheet 1 to sheet 2. However i want to have only new entries copied. if the data already exists on sheet 2 than do not copy from sheet 1. Select distinct only works on input data (using OBDC input). VB or function format would be OK. Been all over the net for this one with no success. Any ideas appreciated.

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com
 
I would use VBA to loop through all the values in sheet1, check if that
value is in sheet2, and copy if not, nothing if yes. Post back if you need
more. Include some info on the layout of the 2 sheets. HTH Otto
 
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

Copying cells from one sheet to another 5
Excel Macro to copy a row to another sheet based on date 0
Paste into grouped sheets using VB 2
Need help Taking alot data from one sheet (if not blank) and copying toa list on another sheet. 1
File placement with copied sheets 1
Macro to copy value in field and insert it into filter 2
Copying a cell value to another sheet by using If statement 1
Saving sheet data to another sheet automatically 7

Back
Top