I want to sort contract numbers in Excel the same way we do in our filing system at work. Our contracts contain both numbers and letters, but excel won't let...

Does anyone know how I can paste the find all into a new column in the same corasponding row number? I did a copy from the "Findfind all" list by...

I'm using Excel 2000 to build a contact list. Several of my contacts have more than one email address and I would prefer to put all email addresses for an...

Hi, how do I get this to save the file to specific location, it just keeps going to my documents. Public Sub SaveAsE5() ThisFile = Range("E5").Value ...

I have a column with nine-digit zip codes, but there is no hyphen separating the final zip four numbers. I need to use this column in a mail merge, but...

I want to search a range of cells, say C:C for a value, if that value is there i want to multiply the corresponding B cell and D cell together then sum up all...

Hello Please help - the keyboard shortcut for "Paste" is "CTRL-V". What is the shortcut for "Paste Values" Thank you!!

Can anyone help me out with this? I want a worksheet to preform these actions each time it opens: Automatically unhide any hidded rows (especially...

Hi, I recentlt Reinstall WinsowsXp Pro on my system and had to reinstall all my programs and apps including OfficeXp. When I opened Excel 2002, a message box...

We have spreadsheets on our intranet Sharepoint Team Sites. If a user opens one of those spreadsheets from the intranet with Internet Explorer, closes the...

Hello All - I have a need to print an excel database file. The file is 3 columns wide and about 1500 rows. How can I print it to paper where it will print two...

Hi got a problem with excel. everytime I open a file the cells are formated in a date format and I have to reformat them. Any suggestions to solve...

Is there any way to have getpivotdata retrieve more than one set of data, other than doing it like below? =GETPIVOTDATA('Roll-up Pivot'!$F$2,"hours enrg E...

Greetings; I have a question I am hoping someone will be able to help me with. My overall goal is to create a dropdown list with a line of data in it. ...

I frequently have to read .csv files into MS excel. These are textual files, containing text fields, floating point numbers, integers and times. The first item...

I am trying to write a bit of code that will look at a cell and covert what's in the cell to some sort of code. e.g. Hello Goodbye Yes No The above...

Hi there Does anyone know how I can have six cells next to each other, using the =RANDBETWEEN(1,49) function, where none of the cells equal each other? I.e....

We have a client that does not want to see the formula in the formula bar. I decided to protect the excel report and hide all formulas, but that is not good...

Hi, How can I use "shell" to move from Excel to the current (default) web page to copy some comma delimited text data, then open Notepad and save it there? I...

I am the accountant for an insurance agency evaluating Office 2007 Small Business Trial Version for upgrading our workstations. Our agency accounting...