So I have this simple macro that refreshes the pivot tables in a template. However, I have it specifying the Sheet number and Pivot Table names. The...

Hi I have 1160 rows of client info with one column being the coutry in which a client lives. How can I work out the percentage of how many times a country...

I would like to add 'Run Date: ' in front of a command that reads a date off of a data sheet. How do I add text to a command?

I have a sheet with a list of part numbers and the time it takes to make each part. On another sheet, I have a list of part numbers with the quanity due and...

When I enter something into a cell beginning with a minus sign "-" then the content is automatically interpreted as a formula. How can I prevent this and let...

I was able to use my arrow keys to tab to specific cells, now it moves the entire worksheet instead. How to I enable my arrow keys to move to cells?

Excel 2003 Columns A and B would have, for example: A B C App1 London AMERICA App1 London EMEA App1 London APAC App2 London ...

I've created a button with a macro assigned to it. I'm trying to save and close an Excel file, then close the application. Then I would like to copy it to...

Dear, I have plotted a line graph consisting the data for the entire month. The data range is getting calculated automatically by a formula. 1 Dec - 100 2...

"The INI file containing the temp chart file name could not be found" What does this mean and how can it be corrected. Recently upgraded from 2003 to 2007

I have created macros to hide and unhide sheets when clicking on a button example - Sheets("Premium Labor Utilization").Visible = Not Sheets("Premium Labor...

Hi An average user with some Qns. 1) I have a spreadsheet with many columns filled up. I wish to select mutiple columns simultaneously but when I press...

Hi, Before I saved an Excel 2003 .xls file it was 168mb When it was saved as an Excel 2007 .xlsm macro-enabled workbook it shrunk to a mere 25mb Just...

Hi All, I want to Filter Date from 01.10.2009 to 30.10.2009. How? Regards Rao Ratan Singh

Need to insert a custom field in a pivot table. Want to compare diff between 2009 and 2008 in one row and then convert to % in another row. My pivot table...

I have two spreadsheets and would like to copy the info from one to the other if the one cell matches the info in the other spread sheet?

I am not able to install the Report Manager add-in in Excel 2007. Is this possible? -- Bob Milliken

When I open a spreadsheet in Excel 2003 I get a prompt to either update or don't update. I do not get the prompt when I open the same spreadsheet in Excel...

I have a PC with Excel 2003 SP3, when you click on "open" the window appears with a drop down arrow that allows you to navigate to your files. This person...

if the cell A1 = 30-Nov-2009 and cell b1 01-Nov-2009 How I can find the number of days between that date. It is for ageing analysis for customers Pls help