[ExcelVBA] Need help on a Macro to compare two spreadsheets

 

I need help or ideas on how to create a macro that will hunt for two cells in one spreadsheet/workbook that equal two cells in another spreadsheet/workbook.

Every week, I will get statistics about usages and it might have 1 or 2 rows of data:

Row\Column:

1 Year WeekNumber Data
2 2012 27 2.5
3 2012 28 6.5

I want to hunt for this data inside my master spreadsheet and if not present create(add) two new rows or if found, then update these two rows with the data from the spreadsheet above. Here is my master spreadsheet/worksheet:

Row\Column

1 Year WeekNumber Data
2 2011 52 6.5
. ..... .. ..
80 2012 26 3.5

How do I start this and what would be the most efficient method to do this.

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 1

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___