Thread: do not copy data to another sheet if exists
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paul Paul is offline
external usenet poster
  
Posts: 25
Default do not copy data to another sheet if exists
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
Reply With QuoteReply With Quote