Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro question | Excel Worksheet Functions | |||
Match and Sort for two range of data on different worksheets? | New Users to Excel | |||
Pull data from another sheet based on certain criteria | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions |