View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JR Form[_2_] JR Form[_2_] is offline
external usenet poster
 
Posts: 28
Default Getting info from one workbook to another

What is the information you are trying to capture?
How often do you need it?
Is this on a network or a local machine application?

You could create a macro in the template to write the information to a log
file.

"ljgent" wrote:

I created a workbook to be used as a template when a new style is designed.
The designer will fill in info for her new design then save the workbook
under a new name to save the template. I want to be able to have some of the
info from the new workbook to go into another workbook to use as a summary
workbook. For every new design means a new workbook.
How could I have each new design workbook automatically be entered into the
summary workbook?
For example the new design workbook is saved as 1000.xlsx I want info from
certain cells to enter into design log workbook. Every new design workbook
info I need needs to appear in the design log book in its own individual line.
I hope I am making sense..
Please help