View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ljgent ljgent is offline
external usenet poster
 
Posts: 10
Default import info from one workbook to another workbook

I developed a technical pack template to be used for each style that is
designed.
Designer opens tech pack and on the first sheet she fills in the heading
with information such as
style #
description
fabric
fabric content
factory
these are all in different cells
When she is done she saves the tech pack using the style # so the tech pack
template can be used for another style.

What I would like to do but do not know how to is in another workbook called
techbook log is when the designer fills in the information that it gets
logged into the techbook log.

The techbook log will have column headings

style # Description Fabric Fabric Content Factory

Is there a way to have the log book automatically be filled in for each tech
pack that is created.
If there are 20 styles there would be 20 tech packs therefore there would be
20 entries into the techbook log. Can this be done and if so how?

Greatly appreciate your help.