We manufacture clothing and I have created a TechPack - the workbook is on a
company network. so when the designer designs a garment she uses the first
sheet of the tech pack with informaton such as style #, fabric , fabric
content, etc. all this information loads onto other worksheets in the
workbook. Each worksheet is for different stages of the garment development.
The first worksheet is where the designer puts the information regarding the
style, like I mentioned above. Then she will save the file in a different
name something like style12345.xlsx.

What I would like to do in another workbook when the designer fills in style
#, fabric , fabric content, description, factory etc. that it gets logged
into another workbook called lets say spring2010.xlsx.
for every style they develop they use the techpac template and save it under
the style # assigned. So if there where 20 styles there would use the
techpac template 20 times and then there would be 20 individual style xlsx
files. So in the log workbook I would like the info for each individual
style workbook entered on a separate line so there would be 20 entries in the
workbook log xlsx workbook.

It would look something like this:
column one style #, column two description, column 3 fabric, column 4 fabric
content, column 5 factory etc.

I hope this is a bit clearer
"JR Form" wrote:

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