Worksheet updates

I have a workbook with several worksheets broke into different areas.There is a master sheet with all the numbers listed, in this case account numbers.
How do I write a macro that would cross reference the updates from either the worksheets back to the master page or the other way around. The references would be in text and they are in column A. The account numbers are in column B. I know this has to be an event macro but I am stuck from there.
Thanks in Advance
Deb

Hi,

Are you sure you do need an event macro ...?

It seems to me that linking cells could be enough ... no ...?

Carim

I can't link every account code on the master to all the different spreadsheets. This would change weekly. I want to be able to compare or match the codes and then bring in the updated text in column A. I thought an Event procedure might
do it because any change on the seperate sheets would be reflected in the master. I can't do a Vlookup because the data will never be sorted and the info I want to bring in is in column A, to the right of the codes. Is there a Search and Match function somewhere that would allow me to bring in a value from column A? I have been reading all morning the posts and haven't found anything yet except possibly the event combined with an If, Then??????

Deb,

You should break down the issue at stake into sub-steps which become manageable ...
Are you familiar with vlookup() function or match() function ... ?

Carim

Well, I am trying to get the index, match array formula to work without much luck. Buy if I could get it to work, how would I incorporate that into a macro?

Deb,

It is a two step process :

1. =Match(RefCell,LookRange,0)

will return a row or column number

2. =Index(Database, RowNumber, ColNumber)

will return the value you were looking for

Hope this clarifies issue for you ...

HTH
Carim

I got something to work.
=INDEX(A2:A5,MATCH(Work_order2,Work_Order,0))
my range A2:A5 is a named range but if I insert the name all I get is the Name. Weird. I will have to work with this for awhile.
Thanks for the advice

Deb,

Please Login or Register  to view this content.

Just make sure

1. Insert Name Define
your name reflects the whole range

2. Do not place quotes " " around the name

HTH
Carim