Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-05-2011, 06:22 AM
AaronMoss AaronMoss is offline Compare and Update Macro Windows 7 64bit Compare and Update Macro Office 2007
Novice
Compare and Update Macro
 
Join Date: May 2011
Posts: 2
AaronMoss is on a distinguished road
Default Compare and Update Macro

Hello,



I have a spreadsheet that I call "Master" and another one I call update. I want to be able to Update rows in the Master spreadsheet with rows from the Update spread sheet.

If the update spreadsheet has a row with part_number "123abc" in column "A", I want to update the row in the master that has the count in Column "G" where column "A" (update) matches column "A" (master)


Thank you so much!

Aaron
Reply With Quote
  #2  
Old 05-05-2011, 05:22 PM
macropod's Avatar
macropod macropod is offline Compare and Update Macro Windows 7 32bit Compare and Update Macro Office 2007
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi Aaron,

You don't need macro for this. A LOOKUP formula in the master spreadsheet pointing to the update spreadsheet should do the job. Without more details of the layout & workbook names, etc, specific advice can't be given.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 05-06-2011, 04:54 AM
AaronMoss AaronMoss is offline Compare and Update Macro Windows 7 64bit Compare and Update Macro Office 2007
Novice
Compare and Update Macro
 
Join Date: May 2011
Posts: 2
AaronMoss is on a distinguished road
Default

Hello and Thank you for your reply!

I have attached and image of the two table, and the macro that i have been trying to get to work, no luck so far

I'm a SQL and PHP and CF person. Excel is so Alien to me right now but i need to learn it seeing it playz a big part with my company.

Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Compare and Update Macro Compare tables and mark differences (vlookup? goodhope Excel 1 03-26-2011 10:29 AM
Macro to update fields rhatx Word VBA 0 03-02-2011 12:14 PM
How to compare certain items in document A & B? networkerz Word 0 10-16-2010 09:55 AM
Compare document enthu Word 1 05-19-2010 10:32 PM
Compare and Update Macro compare files rmartin8 Word 1 02-10-2009 10:27 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:37 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