Microsoft Excel and inserting worksheets

[Thant]

Greetings,
I have what may be a simple question but i have yet to be able to find the answer. I am maintaining spreadsheets for some reports and I need to know how to add numbered worksheets based on the weeks of the year ( Week 1, Week 2 etc). I have found how to add one worksheet at a time but have not been able to find a way to add multiple sequenced worksheets in one shot. Is there a means to do this?
Thanks in advance

 

[mintjulep]

Add multiple worksheets
Determine the number or worksheets you want to add.

Hold down SHIFT, and then select the same number of existing worksheet tabs that you want to add in the open workbook.

Example: If you want to add three new worksheets, select three existing worksheet tabs.

Click Worksheet on the Insert menu.

So the first time you can insert 3. The second 6, the third 12, etc.

But this probably really isn't the best way to format and store your information.

 

[Thant]

Thanks. formatting isnt really as important as the data is copied from a webpage showing exceptions to a submitted report to the state. Is there a way to number the inserted sheets or will that have to be done one at a time?
Thanks again

 

[SkipVought]

Hi,

It is often a scourge in Excel. Excel make it so easy to make big mistakes. One of those mistakes is a workbook design that CHOPS data up into various pieces, like Weeks of the year, for instance. It renders so many of Excel's great and extremely useful reporting and analysis features, virtually USELESS. Within a relatively short period of time, you will be posting questions about how to get data from your various Week sheets into a summary. It's like shooting yourself in the foot!

All your data ought to be in ONE sheet in ONE table, with a proper Date column indicating the appropriate date for that row. With a properly structured table, you can easily, ususlly in mere SECONDS, report any day's, week's, fortnight's, month's, quarter's, year's data. Going the other way, is a path wrought with pain and anguish and paid in fruitless hours.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Thant]

Thank you for the advice and I agree. Normally I would not insert data in this manner. Let me describe the process im using. I submit a report to the state from all 14 of my outpatient pharmacies containing information about controlled substances. The website that i submit this to then generates an exception report on the website with no way to export that report other than copy/paste. I take that copy and place it in a sheet for that specific pharmacy with a worksheet showing the week of the year. The managers take that report from the shared folder and make what ever changes are needed within the pharmacy system itself to correct any exceptions generated in the report In this case the excel sheet is just a means to get them a list of the information that they take and change in a completly different system.
I hope this explains it. I would post a copy of it but due to HIPPA i am unable to do so
Thanks again for your advise

 

[SkipVought]

... no way to export that report other than copy/paste...

Have you looked at Data > Import External Data > Web Query...?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}