Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-06-2014, 12:14 PM
EdStockton EdStockton is offline Appending unique data from one worksheet to existing data on another worksheet Windows 7 64bit Appending unique data from one worksheet to existing data on another worksheet Office 2013
Novice
Appending unique data from one worksheet to existing data on another worksheet
 
Join Date: Aug 2014
Location: Georgia
Posts: 1
EdStockton is on a distinguished road
Default Appending unique data from one worksheet to existing data on another worksheet

Hello,



I have a problem that is not unique I am sure.

I have a master list of customers. Most of our sales are repeat customers. However, we do get new customers each month.

I have a master list of customers that I would like to append with new customers. Sheet1 represents our master list. Sheet2 is sales to customers last month. I want to find unique names that appear on Sheet2 that are not on Sheet1 and append those names to the list on Sheet1.

I would appreciate any help.

Thanks, EdStockotn
Attached Files
File Type: xlsx Name List.xlsx (8.8 KB, 8 views)

Last edited by EdStockton; 08-06-2014 at 12:16 PM. Reason: Need to attach sample data
Reply With Quote
  #2  
Old 08-06-2014, 11:00 PM
excelledsoftware excelledsoftware is offline Appending unique data from one worksheet to existing data on another worksheet Windows 7 64bit Appending unique data from one worksheet to existing data on another worksheet Office 2003
IT Specialist
 
Join Date: Jan 2012
Location: Utah
Posts: 455
excelledsoftware will become famous soon enough
Default

Using the countif formula should do this (It will count how many times the value is in a range) however if this is something that you are going to running a lot it may be better to get a VBA script for it that could do it automatically for you.
Reply With Quote
Reply

Tags
append, data, unique

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Highlight cells with changed data on a worksheet with tracking changes jpb103 Excel Programming 1 06-03-2014 07:33 AM
Appending unique data from one worksheet to existing data on another worksheet How to summarise different worksheet to a summary worksheet samkiewhock Excel 1 09-06-2012 03:34 AM
Appending unique data from one worksheet to existing data on another worksheet "Auto-populating" data-worksheet to worksheet. meggenm Excel 4 02-04-2012 02:04 AM
macro for comparing data from 3 columns and pasting into another worksheet ashukla Excel 1 06-24-2009 05:01 PM
TRANSFER DATA TO NEW WORKSHEET BOBN Excel 0 11-08-2007 10:34 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:40 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft