View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sean Sean is offline
external usenet poster
 
Posts: 208
Default Sending cell information to another workbook....

So here is what I want to do: I have an excel document designed to be a
workorder template, I want to fill information out in this template and have
certain feilds transfered to a seperate workbook (basically a register). This
part is no problem, however I want to close and reuse the template again and
each time have the information from the workorder sent to the ``register`` on
successive rows (1,2,3...) everytime.

Is this possible,
and if so how can it be accomplished...
lastly can a control button be used to export the data to the register...

thanks for the help