I would like to Format cells so that they display time as eg. 3hrs
30mins
Do I need to add a custom format? I

If you record a macro for a regular process but you do not know how many
rows of data will be needed each month how do you change script to cater for
say a total being needed at end of the last rows.

I've just learned how to use the solver add-in to solve sets of
equations. The problem is that this particular set (let's call the
unknowns x and y) has an infinite amount of solutions as long as x is 5
time bigger than y. This means that 5 and 1 is equal to 5000 and 1000.

I have created a small game with a worksheet displaying different colors
etc. in different cells and a few buttons on the sheet. Buttons have
their codes associated with them in the modules. Player has to choose
some cells, enter some data only in some particular cells marked for

I have a workbook set up that consists of several sheets and a summary
sheet that refers to the third row on every other sheet.
The worksheets that are referenced contain dated information that is
sorted with the most recent entries entered in row 3 and these are the

What is the formula to divide a number in a cell by the number of
months to date in the current year?

1. Enter an Excel Workbook complete with 2 worksheets.
2. Sheet1 has a set of custom header and footer.
3. Please show that the custom header and footer of Sheet1 could be
Copy-and-Paste'd onto Sheet2.

Perhaps I am explaining myself in the wrong termonology but when I drag a
cell into multiple cells below it
the formula changes cells.  How do I make it from changing cells.
--

I have run into an issue where i want to be able to create multiple
"Resource Plans" sheet with a macro but to have them created as needed
so to speak. I am trying to create a
macro that can be used to see if a sheet called "Resource Plans"

I am trying to set up a kind of unique time sheet - I want it to have 3
in/out times, and a total number of HOURS worked per day.  This is what
I want it to look like:
B                C

I have a formula that adds two values together and then I want to add 10
percent.   I just don't seem to be able to find how to get Excel to calculate
the percentage of two values added together so far I have the following
=IF(OR(D2="",E2=""),"",D2+E2)

Have a sheet that has data in.
I would like to copy all lines from that sheet to next sheet if one column
as a particular ' variable ' in i.e in this case L which represents a live
case.

Running a worksheet that tracks all household expenses for the year. First
page is Home that contains totals from other pages named Insurance,Medical,
utilities. How do I place a total say from cell k5 on the utilities pages
onto the Home page at f5? I have the formulas set up ...

Hello,  I am trying to find a formula that will allow me to multiply the
value of one cell by simply typing a number into another cell.  For example,
cell "B4" would have a dollar amount of $100; if I was to type in "1" in
"C4," it would automatically total to $100.  Likewise, if ...

I am putting a correspondence review in a big project.  There are 7 columns:
Date, Form, From, To, Re:, Comments, Pages.  Information in some of the
columns contain multiple lines.  What I want to do is, I want to put the
information in and finally sort them according to dates.  ...