Macro fill cell based on value from another sheet - columns change

Hi all,

I could use a bit of help here.

I have a file with a master list of data, titled "Values." In this sheet, I have specific identifying columns - Building #, Floor # and Unit. (Columns B, C and D, respectively). This sheet contains information for all units on all floors in 5 different buildings.

I then have separate sheets for each separate building, with all the same column headings.

What I want to do is have the column for "sale price" sheets for the individual building autofill when a price is entered in to the "Values" sheet [column F is sale price].

I know I could use a VLOOKUP, but I would like a macro for this, unless someone can give me a good solution. My problem is that I (and others) will be sorting the data in the sheets based on multiple factors. For example, I may want to sort by the units in a building (i.e. price for each "A" unit) or by floors (all units on 5th floor) or, on the master sheet, an advance search by first building, then floor, etc... I'm also concerned about someone using the sheet and deleting the vlookup formula in the columns!

Is there a way to do this? Does my description make sense?

See the attached file...

Thanks for all the help!
TY0296.XLS

I am editing this down here because I am not sure I was clear.

When I enter a sales price value into Sheet 1 "Values" (Column F), I want that figure to be automatically filled in on a separate sheet which corresponds to the building I am referencing. So, I am imagining the macro has to check 3 figures - building (400, 424, etc...), Floor, and unit, and if these are all the same, can then enter that figure into the other sheet.

Regarding this macro - I have the following which updates pretty well. But I do have one more question:

Please Login or Register  to view this content.

My question is if I want to expand the number of columns that will update, how do I do that. For example, if I want the macro to update based on changes to column s F G H, what changes do I make in the code?

Please Login or Register  to view this content.