I have a list of consecutive numbers in a column from say 1 to 500. Does anyone know an easy way to take these numbers in a new column and sort them to be...

I have a column for start date and end date. I would like a formular that tells me how many months it is including the start month and end month. ex. Start...

Hi, i have a macro that save excel file to html, and i need a macro to add a script to html when saving. Can this be done? Thanks!

Hi, i have a macro that save an excel file, but i have another workbook in the same folder. i need to replace that file. I need the macro to ignore the...

I was given an Excel Spreadsheet (v2003) and asked to let the user print subsets of data. Is there a way to print out a subset of columns and rows (like using...

I need your help to create a macro or a Visual Basic code that do the following: I have a cell with a macro that shows “Meets� or “Does not Meets�...

i have a excel .CSV file that Gmail generated for me with my contacts in.. what i want to do is function that go over all the contacts emails one by one and...

Hi Please-How do you round up to the nearest $1000.00? Thanks! -- OneFineDay

When I type in the VLookup formula and hit enter, the cell will not display the result - it displays the formula. Then, when I copy it to the cells below,...

This question was posted in 2006. Has the answer changed at all since then? Q: In WORD you can type away on your document, and the header and footer will...

from downloaded file, in A1 have CS1234567 and want the numbers only, used value(mid(a1,2,7)) and instead of 1234567, it returned formula value(mid(a1,2,7))...

Can someone explain mathematically why the difference of the sum of the average of row two and three (Range D2:D3) as shown in cell E3 is different than the...

I'm running Excel'97. Within the same directory I'm trying to import data into spreadsheet cell from a cell in a different .xls file. I've tried...

Just installed 2007 version and am missing the extra menu item that used to be there for Hyperion Essbase add-in. It was at the top similar to File, Edit,...

Is there a keyboard shortcut that will convert my files from 2003 to 2007. Currently I am pulling up each individually and clicking Office, Convert, Yes,...

Hi all! I wrote a payroll program in excel, but when I try to make a "template" and copy it I find that it automatically adjusts the cell numbers, which I do...

Hello, I have 2 sheets; "Sheet1" & "Sheet2": Sheet1: Column A Column B Column C Part Number Qty. P/N &...

I am generating a spreadsheet in excel 2007 and sending it to one of my subs. They then take info from my sheet and from another sheet and link it to a third...

I have several forms that I use on a regular basis at work and having just got a windows mobile phone HTC Touch pro 2 was wondering is there a way I can...

How do I combine an alpha character from one cell with a numeric value in another cell and display the result in a 3rd cell like this: Cell A1 = B Cell B1 =...