hyper link to another workbook
 

-- good day excelers,i have a work book with an invoice template. what i am
trying to do is link pertinet data from the
invoivce to a control sheet in a seperate workbook.i tried copy and past
link,but when i save the
invoice in a customers name the template is cleared and no data shows on the
control sheet.is there a way to save this data to the control sheet from
every invoioce that i save as?
any help would be appreciated. thx wynb.
ps:please disregard the first question i posted (link to another worksheet)
thx wynb.
--

--
wynb