|
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 |
do not copy data to another sheet if exists
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 <Paul wrote in message ... 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 |
| All times are GMT +1. The time now is 03:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com