Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 20th, 2006, 05:21 PM
Authorized User
 
Join Date: Sep 2004
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default Vlookup - Add entries to sheet that didnt match

I have 2 spreadsheets. Source data spreadsheet and Exisiting data spreadsheet. I do a Vlookup in existing data spreadhseet to get values from source data spreadsheet. There may be new entries in Source data spreadhseet that do not exisit in Existing data spreadsheet. I want to get those entries into my existing data spreadsheet. How do I do that?

 
Old September 21st, 2006, 08:04 AM
Authorized User
 
Join Date: Mar 2006
Posts: 73
Thanks: 0
Thanked 0 Times in 0 Posts
Default

is the data held on one sheet, or multiple sheets within the source spreadsheet

 
Old September 21st, 2006, 10:29 AM
Authorized User
 
Join Date: Sep 2004
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default

the data is in one sheet in the source spreadsheet.
for eg source spreadsheet wuld have

name hours
ABC 10
DEF 15
OOO 30

Exisitng spreadhseet data
ABC so a vlookup woul dgive me 10 from the source
DEF and 15 from the source

now OOO name is not in exisiting spreadsheet which I want to
be added from the source spreadsheet everytime there are new entries.
thanks.






Similar Threads
Thread Thread Starter Forum Replies Last Post
Vlookup with VBA andygill Excel VBA 2 November 6th, 2008 06:44 PM
Open Workbook,Copy Sheet,Move Sheet, Close/Save ptrussell2009 Excel VBA 0 June 13th, 2008 02:28 PM
template match doesnt match the required node Tomi XSLT 2 March 12th, 2007 06:24 AM
add xsl style sheet in generated xhtml using xslt. kvmreddy XSLT 2 April 10th, 2006 02:22 PM
Why does self work when window didnt a007spy Javascript How-To 1 September 15th, 2004 02:12 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.