Automatically Saving Only Used Excel Sheets

[spencer695]

Hi,

Is there a way to save only used excel sheets.

I have a spread which contains approx 30 sheets - then they are split for certain activities.

So, is it possible to save for example sheets 1,2,5,19,20 and 24 if these are the only ones that have had information added and used.

Hope this makes sense

[KOKOSEK]

Do You want to save only 6 out of X sheet from one workbook? Am I correctly understand?
How are You imagine that? All sheets are in 1 file.

[spencer695]

Do You want to save only 6 out of X sheet from one workbook? Am I correctly understand?
How are You imagine that? All sheets are in 1 file.

All the sheets will be in the same workbook, but not all of them will be used.

So I am trying to work - that is only certain ones are used, as you say 6 out of x sheets are used, can it be possible to somehow automatically only save the ones used, and maybe then create a new workbook containing only the saved sheets

[KOKOSEK]

That absolutely possible. Export only declared sheets (1,2,5 etc.) into new workbook and save it.
What do you mean by 'automatically' ? What will be a trigger to do it?

p.s. of course, VBA have to be use for it.

[spencer695]

That absolutely possible. Export only declared sheets (1,2,5 etc.) into new workbook and save it.
What do you mean by 'automatically' ? What will be a trigger to do it?

p.s. of course, VBA have to be use for it.

In the pass I have used macros to create print buttons to then once hit will only print the sheets within the programme,

So I am thinking, is it possible to maybe create a macro to to only save the sheets, as it will always be the same group of sheets needed to be saved.

In short - sheet one would be a list of all names, contact details, and activities attending etc, but then if person one is only say activity x then information goes to say sheets 3,5,8, then the next 6 people do activity two then information goes to sheets 3,9,10.

So then I would like to then save the sheets to form new workbooks for activity one say, and another for activity two and so on.

Hope this makes sense.

[KOKOSEK]

For example like that:

Please Login or Register  to view this content.

of course you can assign this into button.

[spencer695]

For example like that:

Please Login or Register  to view this content.

of course you can assign this into button.

Brillant, thank you - I'll give this a try when I get to that stage.