Excel help please

Sunshine_and_Roses

I have a chart that I need to put on 50 individual tab on an Excel workbook.  Is there an easier way than clicking on the tab any creating a copy 50 times?

Brookside88

insert your tabs, copy the table, group the 49 remaining tabs and then paste and it should copy it into all of them

Sunshine_and_Roses

Brookside88 said:

insert your tabs, copy the table, group the 49 remaining tabs and then paste and it should copy it into all of them

Could you tell me how I group the tabs please?  Not done this before.  Thanks

joho

If you click on your first tab and then the last one while holding down the shift key it should group them.

Andy_L

clareski said:

Brookside88 said:

insert your tabs, copy the table, group the 49 remaining tabs and then paste and it should copy it into all of them

Could you tell me how I group the tabs please?  Not done this before.  Thanks

select the left most one (eg sheet2) then hold shift as you click on the right most one (sheet 50) & that will select them all.

you can also hold ctrl as you click & you can select multiple ones by clicking individually

Heedtheadvice

Now I see the queston asked has been answered.......

But then I wonder why you would want to do 50 identical tabs?

First thought is that you want 50 data sets all displayed the same. i.e. something like 50 similar lists with differing data all with the same chart dusplay format such as weekly data.

If so, that is not the best way to do it. It might seem simple but it is more dfficult to control things like changes. Consider you get to week 40 (if it were weekly data) and you wanted to modify or found a problem with the chart you then have to make (potentially, for consistency) changes (identically without mistakes) to 50 tabs!

Far better one data set with a column to identify which on of 50 sets (weeks?), One chart and one of Excels methods to select individual or a collection of those sets.

Just as easy to display things other than weeks......and less prone to errors tab to tab or inconsistencies.

If that appeals ask again with some  clarification.

Sunshine_and_Roses

Thanks for all your replies, sorry for late response and vague description. 
The chart I am looking to do is for a lottery bonus ball, so I need 59 tabs (one for each number) with the same chart on each tab except for the persons name, so I can mark off when they have paid each week or month.
I have done the first sheet for number one with the persons details, so now need to duplicate this and change each name afterwards. 
Which would be the easiest way?  Thanks for your help

Opera12

clareski said:

Thanks for all your replies, sorry for late response and vague description. 
The chart I am looking to do is for a lottery bonus ball, so I need 59 tabs (one for each number) with the same chart on each tab except for the persons name, so I can mark off when they have paid each week or month.
I have done the first sheet for number one with the persons details, so now need to duplicate this and change each name afterwards. 
Which would be the easiest way?  Thanks for your help

Hey, I came across this YouTube video https://www.youtube.com/watch?v=QOlWwaXLkbs
Do give it a watch. I think it will provide you with all the necessary steps.

outtatune

clareski said:

Thanks for all your replies, sorry for late response and vague description. 
The chart I am looking to do is for a lottery bonus ball, so I need 59 tabs (one for each number) with the same chart on each tab except for the persons name, so I can mark off when they have paid each week or month.
I have done the first sheet for number one with the persons details, so now need to duplicate this and change each name afterwards. 
Which would be the easiest way?  Thanks for your help

Still none the wiser as to why you need a tab for each ball, or how that relates to whether someone has paid or note, can you explain a bit more about what you're actually trying to do?

Heedtheadvice

Quite! @outtatune

One set of data, identified by person  date. Paid or not etc. I.e a list

Then one chart probably done via a single pivot table so you can select the person of interest is the usual best way.

So one two or maybe three tabs for data, pivot table and chart. One setup, easy to check, and select person or persons of interest, time period etc. all at your fingertips!

Sunshine_and_Roses

At the moment everything is on paper in a ring binder!!
Each bonus ball number would have its own tab so it would be easy to read at the bottom of the page.  Each tab would have a calender dated for each Saturday so that when each person pays, whether weekly, monthly or quarterly I can mark off on each individual sheet.
It would be on a shared document so a number of people can edit if needed.