Macro to find data from cell and replace data on different sheet
I'm after a hopefully simple Macro/VBA code for my sheet i am using, i
have searched far and wide but my VBA knowledge is quite limited so am not
sure what the coding is doing in other answers.
Basically i have two sheets, Sheet2 has two columns, Column A has a number
in it i.e. 2158 and column B has a name in it. What i want this macro to
do is in Sheet1 i want to type in a number in Cell A1 and a name in cell
B1 and then the macro finds that number used in Sheet1 Cell A1 in sheet 2
and then replaces the name from Sheet1 B1 with the correpsonding name in
sheet2?
Hope that makes sense!!
Thanks
Daniel
No comments:
Post a Comment