VBA - copy from one worksheet and paste/append into named ranges on other worksheets

[MikeL]

Hello,
I have one Worksheet (Sheet1)where a user enters three items:
"FirstName", "LastName", "City" in B1 to B3

I would like to click a button to then take the three values and pastes into other worksheets in workbook.

ie Sheet2 has a named range called "FirstName". VBA to look for that range and append with B1 value.

Sheet3 has two named ranges "LastName" and "City". VBA to look for these ranges within workbook and append named ranges with B2 and B3 values.

Thanks in advance.

 

[steve the fish]

Try like this:

Range("FirstName").Value = Sheets("Sheet1").Range("B1").Value