Looking for more help! This one should be quite simple though.
The system in use relies on the user copying and pasting a section from
one tab to another. This is 8 columns wide, and 7 rows deep. In the past
they've manually entered dates etc etc but I've used formulae to make

OK, my next problem.
I have a cell which calculates the total cost of 'costs' - obviously.
Now, I would like to know how to integrate a warning thing that wil
let the user know when the cost has exceeded a certain value.

This query is as much about mathematical method as it is Excel.
A day-to-day task is to review sales data against expected values. So,
let's say I have 2 columns i.e.
Sold Price    Expected Value

I want to copy the contents of every third column in a row.
I don't know how to reference every third column in a row without
naming each individual column, can someone tell me please?
i'm writing a macro as there are thousands of columns in this

Hello,
I need your help in creating a calendar that converts the dates fro
Gregorian Calendar to Afghani Calendar. Afghani Calendar is sola
calendar which mean it has 365 days. It is not Lunar Calendar. So yea

Hi guys - hope you can help me here. I'm moderately proficient at Exce
but this has stumped me so far...
I've just been posted to a new team in work who deal with sections o
the accounts, namely method of receipts of payments. The mai

For some reason I keep getting a "TOO FEW ARGUMENTS" error with this
formula:
=COUNTIF(OR('DAY1'!E6:E35<>"",LEFT('DAY1'!G6:G35,2)<>"GI"))
I am simply trying to use a count if 2 conditions are met...  1. if

I am trying to write some data analysis macro code and am having problems
with how Excel is and isn't storing the times. During a study a researcher
enters, for example 4:39. That needs to be 4 minutes and 39 seconds.
However, Excel formats it as 4 hours and 39 minutes - as "h:mm". ...

Hello Excel Wizards!
Is there a way to display a number and some text (like 2 or 3 letters)
in the same cell, using *"format cells, custom"* function.
Example: Display 28 tons in a cell as 28 tns. The 28 will keep updating

What time?

I'm trying to take just the column headers/captions and arange them
into a simple list. Could anyone suggest an easier way than cutting and
pasting each individual header into the list?
Thanks

I am a long time lotus user and am now required to use Excell.  I wrote my
first macro--a very simple one, but I want it to continue until I tell it to
stop.  It runs through and doesn't complete a loop.
Here is the Macro:

I am an advanced excel user and this is the first time i have
encountered this problem.
My xls contains a mixture of arrays, lookups and sumif functions.
MY array is pulling through the updated information (eg. a sum of spend

I have several workbooks with monthly sheets in each. I need to format one
cell to print differently than the previous cell if this cell is greater than
the previous cell. I thought I could do a conditional format and then use
fill handle to format the other cells as you would a ...