Vlookup edit button

[MoOsEBoT88]

Hi,

I have a Ref No for each record that is inputted into the system, which is inserted into sheets "search" and one with the Employees name "xxx" e.g. james.

What I want to do is have a edit sheet that I could put in ref number in cell B3, it would show the current record in cells B5 -> B16. (Done this already).
In Cell B5 in the Employee Name.

If I put any new details in C5 > C16 to replace it for what corresponding to in the B Column, on sheets "search" and "employees name" (Cell B5)

If a cell is blank in C, then don't replace anything.

E.g. Total Cost is currently £50 and shown in B16, I put in £100 in C16 and the record is updated in both "search" and "james" sheet.

Then if you press a command button to update the new values.

Hope you can help

MoOsEBoT88

 

[numberman]

Hi,

You can use an event macro to update your list, in this case, probably use the worksheet_change event, first set your target range, and your update range, then use a statement like:

If Not Intersect(Target, Range("update")) Is Nothing Then
'update statement here
end if

Whenever the range changes, it will update your list.

You may find it helpful if you look up worksheet_change event in the help file.


JH