Hi! I have an excel file that needs iteration. However, it appears the setting saved with the file is sort of global: If it is opened with a fresh instance of...

Below is data from two tables. How to I combine them dynamically, while at the same time selecting records that belong to customer CARL? I am familiar with...

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...

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...

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...

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

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...

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...

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 ...

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...

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. ...

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...

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 all, I need to concatenate a word and a number cell. eg, Concatenate("Limit = $",A1) where A1 = $100,000. It shows up like this: "Limit = $100000". However...

I have 2 Excel files. One named "Actual" and one named "Budget". In each file are tabs for the months of the year, "Jan" "Feb" "Mar" etc. The Budget file Jan...

Almost done with my macro! :) Initially, I place my curse in a location. And after a few moves around the macro (Hard coded and Offsets) I want to return back...

Is there a way to limit the size of a text field? I know the max in Excel is 255 characters, but I have been asked to find a way to limit a field to 50...

I need to change case from Lower to UPPER for a range of cells. Any pointers on this will be appreciated.

Convert existing Excel into Data source document to link to existing Mail Merge document to create multiple letters for mass mailings?