Anyone here any good with VBA?

[Lance]

I'm designing a Excel spreadsheet solution for something at work and now I've got all the data where I want it in the format I want it, I need to think about the printing of it, and subsets of it.

Esentially, what I would like to achieve is to have a worksheet which lists in columns A through to F the various worksheet groupings which we would want to print at any one time. Column A would be the complete set with summaries, B onwards the subsets. I think the multiple columns isn't an issue as I will just copy, paste and amend the VBA for each button to pick up the relevent column (which will change in length at some point).

The contents of each cell in each column are the names of the worksheets which I want printing in that group. I've attached an example of all this!

I'm thinking that I need a away of compiling the cells in each column into an "Sheets(Array("CostCentre1", "CostCentre2")).Select" statement but I don't know how to go about doing this!

HELP!

[Rik]

Lovely weather for this time of year, Lance.

[Ray]

It is, Rik,
I'm afraid I'll have to pass on that one, Lance.

[Rik]

 

[zappaDPJ]

If you ask me in a couple of months I might actually be able to do that. My daughter is using it as part her A Level computing and struggling so I'm having to help. We are only a week into the course so I'm not quite up to it I'm afraid. What you're wanting to doesn't look that taxing and I'll certainly take a look but I don't think I'll be able to help yet