You want to copy the cells F14,F16,F19 from the sheet Input Form to your
database workbook.

In sheet Input Form add links to the cells in a row below your data
A50 =F14
B50 =F16
C50 =F19

Now you can copy the range A50:C50 in the code

Use the code from my site now with this range and chnage the workbook/sheet names
http://www.rondebruin.nl/copy1.htm#workbook

--
Regards Ron De Bruin
http://www.rondebruin.nl



"tanyhart" wrote in message
...

I would link the workbooks?

Is the code that I have correct or would I have to edit it?

Tanya


--
tanyhart
------------------------------------------------------------------------
tanyhart's Profile: http://www.excelforum.com/member.php...o&userid=35148
View this thread: http://www.excelforum.com/showthread...hreadid=551008