Matching Cells on different worksheets

[Tom D]

I have a master list of items that contain a date, time, and description, on
one sheet. I have 6 sub lists. I want to be able to match between the
list and the sublist and then put the date from the master list on the sub
list. How is this done?

 

[JonR]

Are your lists on the same sheet or different sheets? Do you ever add new
items to your master list? Is there a chance of duplicate values?

Your solution will require some VBA code. I suggest you start trying the
Find Method to match the values you are trying to compare, then use this to
determine the row containing the right date and then setting the target cell
value equal to the value you are looking for.

If you need some help withthe VBA, let me know.

 

[Tom D]

JonR,
The data is on different worksheets within the same workbook.

The only thing on the Master List that should change will be the cell that
has the date. Basically, I want to have the Sub-sheet go out and find a
match on the Master sheet, get the date for the match from the master sheet
and put it on the sub sheet.

 

[JonR]

Tom,

Try this (suprised I didnt' think of it before). I did thi on a workbook
with two sheets named 'Master' and 'Slave'.

Enter this formula into the cell on the 'slave' sheet that you want to look
up and display the date.

=VLOOKUP(A1,Master!A1:B10,2)

the value that you want to look up is in cell A1, the lookup range is
Master!A1:B10, and the target column (the one on the Master sheet with the
date) is column 2.

This is probably a lot easier than Visual Basic, and will run a lot quicker.

Hope this helps. It will cause you problems if you have duplicates in the
Master table.