Hi, The basic problem for me is I don't know much about VBA or macros, as I am into PeopleSoft. When I am opening an excel report which is generated by a...

How do I open a quatro 9 file with .qpw file ext using msexcel2003?

I import names and address in ascii format into excel. All the letters are lower case and I need to change the First Letter of the names to Upper case. I...

I need to move a list of address from Word to Excel so I can import the Excel data file into a shared Outlook address book. I can simply Copy & Paste, but...

Within a cell I'm attempting to create a number of bullets e.g. 1) get tickets, 2) get money, 3) take out dog Visually can I create a list which would look...

class problem; sensitivity reports used by prof show headings final value, reduced cost objective constraint, allowable increase,allowable decrease (etc); mine...

Alan Wrote: To find the last row of data try =LOOKUP(2,1/(Data!A$1:A$200000),ROW(Data!A:A)) use this with ...

hi, I've got a 'quotation system' and i need to work out a way, so when i press i button (I've got the button) it recognises the last entry put in 'Customer...

I have about 50 worksheets in a workbook and would like to change the date format in all. Is there a way to change all at once or must it be done worksheet by...

How do I install from the Office 2000 installation disk?

How can I make msgbox like this? ¡÷ there are X sheets of this workbook the first page name is : Sheets(1).Name the secod page name is : Sheets(2).Name ¡õ...

I need help creating a formula to do this: If the value in n3 equals the value in w1 return the value in x1 OR if the value in n4 equals the value in w2...

I have only been able to open Access in my software bought at Staples on Friday. All of the other programs will not accept my number from the CD case. Anyone...

I'm trying to write a math formula but I don't know how to write it. Could someone help me. I'd like it to say, if cell E7 is greater than cell E8 then Cell E9...

How do I make the text fit in a cell. I want to be able to print the page with all of the words in the cell even if it has to make the cell larger, without...

How do I draw the opposite of an underline to delineate the term under the square root sign or to denote 'average x', in words, x-bar inside an excel formula...

I'm trying to split the viewing window, but the option is grayed out. Anyone know why this is and what to do about it? Thank you in advance.

In Sheet 1 I have a class lists with students details( names, nationalities, etc), I need to extract the students names only from this sheet and list...

I would like to frint a paper from excel to run the long way as the top instead of the short way or turn the whole page on its side

Hi everybody, I have the simple question about the excel. Let's suppose I have the cell with the text in excel worksheet. I need to edit this text inside the...