Hello Everyone - Here's what it is: I use an Excel-based form to order product. What I want is to set up a chosen cell to show the date of the...

Hi this might be long but I thought someone out there might be able to help. Here goes: I have 2 columns, the first (Column A) is a project number and the...

Hi, I have a sheet where jobs are entered as a list, col A is the job number. This joblist.xls file is 2.2 Mb I have an invoice template where in col A i...

I need help in determining a formula for this problem please. These are my data: LNAME FNAME CODE Smith John 123 Samuels Billy ...

Does anyone know if there is an Excel worksheet function that calculates compounded growth rate? As in: compounded growt rate = {-1}*100

Hello, I have a range on a worksheet which at any given time may vary as to length, etc. As such, I am attempting to use variables in the autofill function...

If anyone can give a hand in this that would be awesome. One of our users in this office is unable to send and Excel 2000 worksheet as an attachment when...

I'm trying to analyse a set of data. However, the data is a CSV file with almost 1.5 million rows, which somewhat excedes the 65 thousand or so that excel can...

Is it possible to schedule macros to run on a daily basis? If so, how would I go about doing that?

Does anyone know if it is possible, and if so how to have a column header move with the data? I have a sheet with a ton of data and the list is growing, I...

I am familiar with IF statements, however, the limitation of having 7 "thens" has me stumped. The situation is as follows. I am doing a sales...

1. I have five stores. At the end of the day each stores enters stats for the day in an excel worksheet and saves it. 2. I would like to open up a worksheet...

On a network newer XP computers take 10 to 15 minutes to save certain spreadsheets stored on a network drive whereas older Windows 95 computers do this in a...

Hi all, My current code allows someone to to click on the combo box and enter the first few letters of a word and if it is in the combo box it is picks...

Can anyone help?! I have a listbox with four options set up so multiple choices are allowed. I would like output in a seperate sheet that records which...

I experimented with Text to Voice and now I CANNOT TURN IT OFF! It operates in every spreadsheet and in every cell - it is driving me nuts! Please - how do you...

Is there any option to auto fill cells (say B2:B4) with formulas from cells above (A2:A4), when (immediatelly after) cell B1 is filled? I know it is possible...

Hi, Could anyone show me how a '#' can automatically be entered in front of any text I type in a cell, please? For instance, if I type in cell A1 'voodoodan'...

Here's a similar question. I imported a table into Microsoft Excel so I can do bar graphs. I created a second worksheet where I could create a sheet...

Hi I have an excel database imported from another package wish to use the address field in a mail merge. However the address field is all in one column and I...