How can i convert a 2 digit number of months to a four digit showing years
and months?
35 = 0211
24 = 0200

My Numeric Data spans 61 columns and many rows. The Data comprises Numeric
Values and Numeric Labels. The Numeric Labels and Numeric Values are in 2
separate consecutive rows of data, a blank row and then a new set of Numeric
Labels and Values in 2 separate consecutive rows, a blank ...

I am trying to find a faster way to complete my variance reports. Up until
this time I have been manually marking out the duplicates and at times there
could be 30 or more pages of information. Too time consuming.
Recently, I was given the below formula to format a worksheet with ...

I AM TRYING TO SET UP A FORMULA ON BREAKDOWN PERCENTAG, EXAMPLE
4550.60  IS THE FU LL AMOUNT , BREAKDOWN 20% TO DIV. ONE, 67% TO DIV2
ETC. HOW DO I SET UP EACH CELL FROM ONE AMOUNT 4550.60

I know how to use e.g. MOD functions to conditionally format alternate rows
with shading, but what is the best way to do this if your data is in groups
so that you rather than have alternate rows of grey and white shading, you
might have 5 items in one group that you want grey, ...

Is it possible to print multiple copies of an Excel worksheet with progressive
numbers

I use this macro on one of my workbooks and it worked awesome - it creates
tables from selected worksheets and names them according to a list of names.
Asuming that the list is named SheetNames, then
Sub maketable2()

I'm making a timesheet and it's working good.
But I can't work out how to calculate mu working time from ex: 15:00 to
18:30 lunchbreak and then 19:20 to 02:00. The calculated anser I get is
"-13.83"

Is there a formula to make cell A5 show the name of the tab for that sheet
automatically?
Thank you for any help

I need a statement that (+IF (j2) < today etc) that if this is true will copy
that cell from one sheet to another sheet can anyone help please.

I need to use a formula like sum(c1.c5)/r[4]c[-1].
Since as and when I add any rows between row 1 & 5 the formula should
automatically change to sum(c1.c6) but the cell as a divison should always be
the value in the cell 4 rows down in B column.

I need a formula to calculate time units for concurrency issues and for
descrepancies in an audit. What I need below:
1.)  a formula to calculate the minutes in 10 and 15 min incriments.
This formula should divide minutes by 10 & 15 min incriments. We then need

I have a row of 10 binary values in a row (column a to J for example).  an
example follows:
0010011000
I need a formula that will return the position (numerically) of the first

I am developing an Outlook solution in which we read a log that is an Excel
spreadsheet that has a name range assigned to the data that is being imported
into Outlook for a list box display.  Outlook has the capability of reading
the number of rows in an Excel named range and ...

is there any way to sort worksheets other than using the move or copy option?
How to alphabetize multiple sheets at one time.