PDA

View Full Version : create wbook from wbook template



sal21
11-14-2005, 02:40 PM
Assuming i have template.xls in c:\test\
I open wbook MASTER_INPS.xls.
Into this wbook MASTER_INPS.xls is present a sheet TABELLA.
Into column A of TABELLA are present many value.

Is possible to filtre based TABELLA column A, the value into column A of A.T. CAMPANIA, after the copy entire range filtred from A.T. CAMPANIA sheet, save in c:\test\ the realted TEMPLATE renemed with: name=name of criteria filtred for example: 4500_&date_of_system similar 4500_14112005.xls

Cicling this creation of new wbook for each value into TABELLA

example:

the first value into tabella is 4500, filtre all data into a.t.campnia with index in A 4500, copy all range selected and put into wbook template from A3, save the template wbook c:\test\4500_14112005.xls...

the second value into tabella is 4501, filtre all data into a.t.campnia with index in A 4501, copy all range selected and put into wbook template from A3, save the template wbook c:\test\4501_14112005.xls
ecc...

sal21
11-15-2005, 05:22 AM
Assuming i have template.xls in c:\test\
I open wbook MASTER_INPS.xls.
Into this wbook MASTER_INPS.xls is present a sheet TABELLA.
Into column A of TABELLA are present many value.

Is possible to filtre based TABELLA column A, the value into column A of A.T. CAMPANIA, after the copy entire range filtred from A.T. CAMPANIA sheet, save in c:\test\ the realted TEMPLATE renemed with: name=name of criteria filtred for example: 4500_&date_of_system similar 4500_14112005.xls

Cicling this creation of new wbook for each value into TABELLA

example:

the first value into tabella is 4500, filtre all data into a.t.campnia with index in A 4500, copy all range selected and put into wbook template from A3, save the template wbook c:\test\4500_14112005.xls...

the second value into tabella is 4501, filtre all data into a.t.campnia with index in A 4501, copy all range selected and put into wbook template from A3, save the template wbook c:\test\4501_14112005.xls
ecc...