How to auto generate excell sheets based on set of values?

Closed
beginer7 Posts 1 Registration date Sunday 8 September 2013 Status Member Last seen 8 September 2013 - 8 Sep 2013 à 00:15
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 10 Sep 2013 à 10:25
HI,

I have a sheet with one set of values as height, width and quantity which work on formula.
I have 10 set of values, but now i am copy pasting sheet and entering each set of values to get the list for each sheet, I know there must be a easy way to generate with a summary or header sheet where i can give those values which can generate the new sheets based on each set of values seperately, can you help me doing this. I want the header sheet to create seperate sheets based on the set of values, say 25 set of values i got, i need to generate the 25 sheets with to create the same formula with each set of values.

Can anyone help me on this ASAP.

thanks
Related:

1 response

TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
10 Sep 2013 à 10:25
Hi Beginer7,

Not clear what you mean by:
quote
I want the header sheet to create separate sheets based on the set of values
unquote

I understand you want to create sheets based on a specific sheet, but what you want to do with those generated sheets, has eluded me.

Best regards,
Trowa