i'm using Excel, for some reason, i can not type longer than i could in the cell. even though there is room to fill, the program keeps me from typing in the...

Hi I'm new to spreadsheets and I suspect this problem is very easy to solve, G2 is a value of £1048.00. In H2 I want to show this as a percentage gain from a...

Hi, I have a spreadsheet where each row contains anywhere from 1 to 8 names ($G$4:$N$4). I need to combine these names into a list box for use in a pivot...

I was given a spreadsheet with the following columns: a button column (to run a macro) a persons name 6 monthly columns of figures When the button is clicked...

I currently have a VLOOKUP function set up in a cell. I am interested in setting up a conditional statement that goes something like "If the drop-down cell is...

Hi Experts I am preparing excel worksheet. I have developed macro in that sheet. The purpose of that macro is " When programmer finishes programming, runs...

Hi Experts I want to group 12 cities in 3 different groups named as class A, class b and class c . three colour assigned to each class. when I enter a...

Hi Bob, Thanks for the quick reply. I've tried it but it didn't work as expected or maybe i did something wrong. I've already click and paste the script as...

NEWBIE ALERT*: OK, please bare with me. What is the method for combining multiple if statements in one cell's formula? In English, the formula would be...

How can I to add code to a Microsoft Excel's form created by program? I try with : VBCompForm =...

Hi, again. I am using EXCEL 2003. I need to import several specific sheets from a certain xls file into another xls file. I can't find the information on...

GDay All, I have a spreadsheet with a number of columns. In these columns, times will be entered (probably 24 hour style). I need to compare these times...

I need to read through a word document (Table) The table has merged cells for Heading Part No Description Price ==================== Widgets A12344 ...

Is it possible to merge workbooks so that I can take data from them all to make a chart? If so how is this done? I have a workbook for every month and need...

Hi JE McGimpsey The solution you gave to me is working. Thanks for that. You have actually given me code in VBA. IS it possible for you to guide me to use...

I am trying to put dates into the workbook, but as soon as I hit endet after typing "3/14/2005" I get #### all in the ccell and no date. What in the world is...

Hullo, I asked this question before but perhaps I was less than specific. I want to place a currency symbol, by itself ,in a separate cell or column when...

I want to change how this works, I messed around a little but no joy. In cells C6,D6,E6 I have words date, month, year, In cells G6,H6,I6 I have words...

I am having to convert all files from Quattro Pro to Excel. When I open a document in Quattro Pro which has several other documents linked, the program will...