I need a method of updating a set of data held on tab1 from tab2 where
details of one record is shown using VLOOKUP, possibly via a macro?

For example:

Sheet 1 holds info on various companies - (Column headers: Name, address1,
address2, postcode, "DATE LETTER SENT")

Sheet 2 Uses a drop down menu to select the desired company and some VLOOKUP
formulas show the info from sheet1 on that one particular company.

Sheet 3 There is a printable standard template letter which draws info from
the record selected on sheet 2 (using standard =Sheet1!A1 formula) formated
so the letter is addressed to the specific company selected.

Back to: Sheet 2 - At the bottom there is a button which says 'Print' This
runs a macro which selects sheet3, prints it then returns to sheet2.

I need this macro to also go back to sheet1 and update the relevant record
with ideally todays date (the date the letter was printed) in the "DATE
LETTER SENT" column mentioned before but can just be an 'X' to show a letter
has been printed for this company/record at some point.

So in the future, by looking at sheet1 you can easil determine which
companys have had letters printed against, and which havn't.

Is this possible? If someone could come up with something or point me in
the right direction it would be sooo much appreciated.

Thanks in advance.

Gavin.