How do I not "grey" it in?
In the code above (post #9), add the following line:-
just above End Sub.
Can I do it without hitting a transfer button and just by clicking on the drop down?
In the Master sheet, remove the blue button.
Leave the code in post#9(with the newly added line) in its standard module. In the Master sheet module, paste the following code:-
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("E1")) Is Nothing Then Exit Sub
If Target.Count > 1 Then Exit Sub
To implement this code:-
- Right click on the Master sheet tab.
- Select "View Code" from the menu that appears.
- In the big white field that then appears, paste the new code.
Now, each time that you select a new city from the drop down, the relevant data will be transferred to the Master sheet without having to click on a button.
Nevermind on #3, I got that one.
'=HLOOKUP(E1,'Base Rent'!A1:E311,MATCH(B1, 'Base Rent'!A1:A517,0),FALSE)
Excellent! Well done!
Here's the link to the updated sample file:-
I hope that this helps.