Go Back   Access World Forums > Apps and Windows > Excel

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 12-12-2018, 04:04 PM   #1
PNGBill
Win10 Office Pro 2016
 
Join Date: Jul 2008
Location: Tokoroa, New Zealand
Posts: 2,264
Thanks: 71
Thanked 78 Times in 74 Posts
PNGBill will become famous soon enough
Copy New Data Only ??

Hi Forum,
Is it possible to Copy Rows from Workbook A to Workbook B where they do not already exist in Workbook B ?

Workbook A is populated by MYSQL from a Database and overwrites data.
Workbook B has 5 Columns from Workbook A.

It would be great if the code to Copy from Workbook A to Workbook B only copied Rows not already in Workbook B.

This is not a task we do every day so speed is not a priority.

Appreciate any advice on this

PNGBill is offline   Reply With Quote
Old 12-13-2018, 03:17 AM   #2
Gasman
Enthusiastic Amateur
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 3,490
Thanks: 379
Thanked 595 Times in 577 Posts
Gasman has a spectacular aura about Gasman has a spectacular aura about Gasman has a spectacular aura about
Re: Copy New Data Only ??

I do this by using a VLOOKUP in a column against the target workbook, and then copy everything with #N/A in that column.?

HTH
__________________
Access novice. Sometimes trying to give something back.
Access 2007


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Gasman is offline   Reply With Quote
The Following User Says Thank You to Gasman For This Useful Post:
PNGBill (12-13-2018)
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
copy data from main table to sub data qupe Forms 3 06-17-2017 12:34 PM
Copy data in sheet1 using sheet 2 and Access table data. aman Modules & VBA 25 08-21-2014 10:33 AM
Copy data from one Excel sheet to another but on if data in to columns match solsearcher Excel 4 10-09-2013 04:08 AM
Qry to copy data and edit data from one field to another Maclain Queries 7 09-30-2008 01:39 AM




All times are GMT -8. The time now is 01:07 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World