Hi,
is it possible to programme an option in a validation
list so that when the option, say "print", is selected
the last row of data entered on a worksheet is copied and
pasted into the next available row in another worksheet.
For example, when the "print" option is selected from the
drop down menu , all the data on cells A5:P5 are selected
(as this is the last info enterd on this worksheet) and
then paste it into cells A45:P45 in another worksheet as
this is the next available row !
Hope I have made myself clear and thanks in advance