Hi I am running a macro that copies a range from an open workbook and paste it to another open one. When I run the macro without vlookup function (in about...

Hi, For ex: In a cell, lets say the value is 'Microsoft'. i want to create a button or a macro such that, if i click that it should insert ')' before...

Hi How do I make the contents of a cell appear like a list (only for presentation reasons), Any help would be great...

I am trying to lookup 2 values in sheet2 which should go into sheet1. I'll try to explain. Sheet 1 needs to look up the name of a person that is in both...

Excel will always display overflow text in blank adjacent cells. Is it possible to stop this?

Anyone know how to write macro/formula that will convert "a column" of Hex to decimal? I'm looking for a hex conversion by cell content, rather than...

I want to copy data from a workbook to overwrite data on another workbook but not to overwrite the formulas. The original worksheet will have either...

How do I set up Excel to open a new instance/application window when I open a new file?

Even after selecting skip blanks in the paste special menu in excel, it is copying the blank cells

How do you create the formula for the following: If cell X has a certain character (1,2,3,4,5,6) then I want cell Y to be populated with a determiend value...

Nothing happens when i try to open excel

How can I download a template if I get Error On Page Message

I have columns of data with the date entered in column A in format MM/DD/YYYY. Column C contains cost data. I am trying to sum up data to the side by month. ...

I have a column with a long number, similar to a VIN number on a car. I need to be able to display only the 3rd and 4th digits, which represent the...

Doing work for someone. They have Excel 2000. Work is done in 2003. Can this be sent as an attachment and opened?

How can i count hours between this two days in excel? a1 2/8/2007 10:00 b1 2/9/2007 23:10 the sum should be 37 hours 10 min

Excel 2000, Windows 2000 A couple of questions: In the number format dialog there are some "accounting" formats shown as templates, e.g.: _($*...

Hello! I have a spreadsheet in Excel and have a lot of data in one of the columns. How can I make each row taller, and change format so I can have several rows...

Hi I have a strange problem that I can't work out. In sheet 1 A1 - A10, I have a list of Surnames. Sheet 2 to sheet 11 are named according to this...

Hi everyone, I need to round numbers as part of a formula and can't figure it out. Say I have 72.5 and need to divide it into 3 I get 24.16 (then I need...