Hi All, I have a stock ageing sheet for finished goods, which uses a vlookup table, on entry of the Product code (last 3 Digits), this populates the next...

Hi, i need to make my chart add figures into a running cost as certain dates of the month arise. example: a cost of £10.00 due on 13th Sept will not show...

Hi I've seen this mentioned a couple of times, but what is a 3D formula? In idiotspeak? Thanks Steve

HELLO, I have a question for you guys...I have a worksheet with 12 Sheets: A; B; C; .....K;L. I would like to record a macro in VBA wich alows me to put in...

If only I could attach this darn spreadsheet. It looks awful, and I can't get the dollar signs to line up properly on the left hand side. This should be a...

I have 34 worksheets within a workbook and I have hit a bump in the road.... On the second sheet, i have made a forumla to pull in data from certain cells on...

How can i do a simple hours (and minutes) x hourly rate calculation and have it display the correct amount in local currency

Due to the number of sucessful attacks that damage the files of the everyday computer user, Microsoft should develop a chip that has at least the operating...

Hi all i had a problem of shifting selected rows one cell to the right, the data looks like this:- 328 Sales $ 0 0 0 0 0 0 Qnty 0 0 0 0 0 0 0 509 Sales ...

I need help creating a cost range for the following scenario. If the value of cell A1 falls between 0-300 I need the following cell A2 to say $0-$300 or if A1...

Does anybody know if it is possible to break the scale in a column chart? For example, if I have one outlier in a series but still want to show it, can I put...

Pls Help.... The command for cutting and pasting a single row looks likes...

In Excel 2003, when I link a cell in pivot table, it copies Getpivotdata formular. And when I drag or copy this cell, again it copies the formular. Can you...

cell A1 has start date (eg) 12/08/05 cell A2 has end date (eg) 25/08/05 and cell A3 has the formular that displays a the number of sundays occured (in this...

I have two sheets, and I want to link information from one to the other. The difficulty is that on sheet 1, the data is entered in every consecutive cell down...

Hello All In a cell, I have the start date of the current tax year(Apr 05) In another cell (Say A2) I would to read "FOR THE TAX YEAR APR 05 to MAR 06" Any...

Hello, I live in Toronto, Canada and want to upgrade from a microsoft works version spreadsheet to EXCEL 2003. How do I go about doing that. I did...

When I try to hide a column with the regular procedure (select the column, Format, Column, Hide) I get the message "Cannot shift objects off sheet" and the...

I have these values in sheets. Sheet2!A1 = 5 Sheet3!A1 = 7 Now, I put Sheet1!A1 = "Sheet2" which can be varied to "Sheet3" or "Sheet4" etc. User has to...

When I enter a date in a cell (ie. 9/14), it is treated like a formula. I have formated the cell (Format, Cells..., Date, *3/14/01) but it still comes out as...