automate creation of sheets in excel
is there anyway to automate creation of sheets in excel? I would like to
have one sheet that has a master list of all items. then a have sheets which
are automaticaly generated, 1 sheet for every 30 items on the master sheet.

is there anyway in an excel macro to reorder the sheet tabs from left to
right?

sorry but only used the fairly common features of Excel & not sure if this
is possible?
I have a spreadsheet (currently in Excel 97 format) with 8 worksheets on,
there is some information I need visible on every worksheet - do I have to

Excel 97's gone funny and it is now adding 2 spaces automatically afte
a decimal point on existing and new spreadsheets as they are typed.
don't know what's caused it, can somebody please help. Cheers
--

Is there some type of code that I could put into VBA for a user form so that
when the user clicks "Enter" that an email is sent to someone letting them
know the excel file has been updated?
The form will be used within our LAN/WAN and we do have our own e-mail

Can anyone tell me how many sheets can you have per workbook? I als
need to know how to combine one spreadsheet with another.
Thank you in advance.  :
--

I have a IF formula in a cells H4:M4 that says HIDE or UNHIDE based on
a condition in another cell.  I want to hide the column based on the
HIDE/UNHIDE value of the formula.  I want to be able to change which
columns are hidden based on the result of the IF formula, as it changes

I have created workbooks to analysis data for my fishing. There are 12
workbooks (each containing 48 sheets), one workbook per year for the last 12
years, each approx. 12,600KB. Each years workbook is linked to the following
years workbook by some 1000+ cells.

I can't run a macro from VB .NET because it not active this square.
is there some form to activate it programmaticly?

HI :)
Does anyone have a template, or info about setting up a spreadsheet to track
gift voucher redemptions/codes/etc?
TIA

I'm stucked with the following: I try to retrieve a result (column
C)via a combination of a INDEX and two MATCH functions, the first MATCH
needs to be matched exactly but the second MATCH has to be defined as
the closest match.

Dear friends,
Everytime I type the Date of 10 Dec. 2005 as 10/12/2005, it converted to
12/10/2005 and it refused to be modified when I try to adjust it from
FormatCells.

HELP!!!!!
I want to be able to automatically print a label from excel when i
input data.
the data will be sent to excel automatically from a software package

I have told create a Spred Sheet. Which has 2 inter-related Columns.
Eg : Column A Should have Provision For Selecting a product from the drop
Down list ( Product_1 , Product_2 )
And i have Other related Drop down list to Select from the Column B.

hope someone can help, i have a spreadsheet that has daily sales, monthly
sales and yearly sales which (forgive my explanation i am a complete newbie
lol) when i enter a new value in the daily sales, i want the monthly sales
to increases but also add the previous value, and the ...