Hi All, Can any one help. Am having a bit of trouble with my VLOOKUP code for some reason it is returning a value for were there should not be one. The...

I have data that is in the format of 3 columns wide by about 3000 rows. I want to rearrange each row to become a single column. Eg. Cells A1,B1,C1,A2,B2,C2 to...

Some keys on my keyboard is locked in Exel. How do I unlock it?

How do I remove page breaks? For some unknown reason they started appearing on a spreadsheet recently. I see dotted lines dividing up the sheet and large...

I need to format the number cell so that it will still show the numbers after the decimal, but not show the decimal point at all. It must also display leading...

Thanks guys. I knew there was a better way. -- Regards, Fred Please reply to newsgroup, not e-mail "Domenic" wrote in...

I have lists of student names and their identiification numbers ans want to be able to scan these into another excel document from a printed form. I can print...

I want to be able to add months or years to a date. For example 25/4/05 + 9 months 25/4/05 + 15 years. I am using Excel 2000.

Hello, I have a set of workbooks that all have a similar macro in them. Each of these macros contains a string I need to change, but to change it manually in...

With Excel 2003 I am encountering the following: If I open an existing workbook directly by clicking on the file and make changes to that workbook, the program...

How do I embed a picture in excel so that it will mail merge into word?

Is there any way to force comments to appear where I want them to appear instead of where Excel thinks they should appear. I want them displayed only when the...

I have a worksheet like this: / A / B / C / / 1 / water per day / cumulative water / beginning water / 2 / 21 / 71 / 50 / I want a running sum in column B. In...

I have a master spreadsheet with contains employee detail by department. How can I filter this list by department and place a list for each department in a...

If you... ....want a loan! ....want a credit card! ....want to invest money! ....want to shop for Christmas! ....want to buy a car! ....want to buy a...

I am fairly new to Excel, but I need the formula to calculate hours worked, to include 30-60 min off for lunch. Formula must include hours and minutes worked.

In Excel under File Properties Statistics it includes the name of the last person who saved a workbook. I want to include in the footer. How do I do that?

I'd like to create a macro that fills a formula down to the final row that has any data. -- Just filling to adjacent cells (e.g. double-clicking on the...

I typed up some History notes and saved it. I wanted to use the same format from those History notes for some new History notes and I saved over on my old...

i am working on a project where i am making a pricebook program. the user will have many products to choose from and these products will be separated into...