The way I have a macro setup right now I can import multiple text files into one worksheet. THe problem is it stacks it on top of one another going down two...

cannot get excel 2002 to open, cannot go to help file, program opens, then stops

I am creating quite a large workbook with in excess of 50 worksheets. I am currently having trouble as I cannot add any furhter sheets or change information...

Hi, I'm having trouble working out formulas for a weekly work hours sheet. Everything was ok untill I added some extra columns to cover Bank Holidays. If I...

Somehow my Excel has lost the "file" option, so I can't "print", or "save as", unless I click on the pictures in the toolbar.

I'm trying to find the slope and intercept of a chart from a set of values in Excel. I'm using Excel 2003

Can someone give me a formula (or whatever its called) to add a column that would be set like this: A1=3000 A2=6200 A3=2250 (1625) A4=10500 A5=6600 (4566) etc.

What I'd like to to is the following. I have many rows, some with data in column A and some with data in column B. I'd like to do is if there is data in BOTH...

Hi I have an excel form which is emailed by users once a cmd button on the form is click. Is there anyway to code in a message in the main body of the email...

I can't get the color, or shading to happen in excel and some other office programs when I am in my normal user part of Windows XP. If I change users (to...

I have a problem when I importing data with Excel 2003 query from Informix with ODBC. Preview shows everything ok but when importing data to the Excel sheet it...

Hi, Anyone know where I can get a Mortgage calculator that will show me Capital/Interest payments at any given point in the Mortgage (i.e. After 3 Years the...

My problem is as follows. My sheet consists of a a range of dates. I need to assign a date to the specific month like 01-04-2005 would be assigned as April or...

hiya guys and gals I have a big problem. I need to make a spreadsheet for work. i'll try to explain as best as i can. Cells A6 to A64 contain the numbers 1...

in vba hi how do i make a formula to give me the average of a strip of data say a6 until the last piece of data in colomn a and then in msg boxs 1)tell me the...

Please give me the reply. I need it very much

in my csv file, there is a string '123', but when open it, Excel treat it as numeric and so use right alignment, any method to force Excel treat it as...

I am trying to calculate the time difference between to cells. I have a formula that works ok unless the difference is in excess of 24 hours. I am using time...

Does anybody know how to use Pantene colours in Excel cells? Or at least get the RGB option, or load new colours? Would really appreciate help. Thank you

I have a problem where I'm looking for a general approach rather than specific answers... ...I have a string such as P1234 and a series of rules that assign...