On one worksheet, I have a "table" with a header column & header row, along with data. ON another worksheet, I would like all of the data in the first...

I have a pivot table that has the following characteristics (Excel 2007): -rows (down the left) are values: "# Employees", "Total Pay" -Columns (across top)...

I am trying to insert a command button so that when the user fills out the form and clicks the button, an amount will calculate. For example, the sales price...

The macro/VBA coding below is an adaptation of Ron de Bruins macro for extracting certain sheets from a workbook and creating another workbook which is then...

Hello All! I note that m.p.excel.misc disappeared this morning from msnews.microsoft.com. It seems to be alive and well on eternal-september but I restored...

This very short macro below creates a userform which can be searched to find the required contract number. However when it is "run" an error message appears...

I'm doing financial reporting for an entire fiscal year different distributors with over 49000 rows. First I would like to highlight cells that have a higher...

I would like to Remove ALL hyperlinks instead of one by one in Excel 2003

My IT dept have removed my documents and settings folder as it was causing problems and all of my old settings have been lost including my macros on the...

Hello - how do i round a number up to the nearest 50p

I have a column, J, that has a mixture of hyperlinks and text or comments. I want the hyperlink to remain blue with the double underline and the text to be me...

I entered few dates in Column C3 to C20, few of them are duplicates. How can I count total number of dates (excluding duplicates), duplicates should be count...

When using excell my keyboard recognition slows down to the point I have to sit and wait for a few seconds. Does anyone have any idea why this is happening...

I have a number of files which were created in Excel 2003 (and have only been modified in Excel 2003). I have now switched to Excel 2007 and when I am saving...

Hello I have a list of 705 patients with four different columns with data in it. I need a random sample consisting of 150 of those patients. Can someone...

Hi all, Is there a way to insert a row automatically in between a different number when the number change?. Like creating a macro or something. I do not want...

Using Excel 2003 and am trying to format cells depending on a range of values e.g. If the value is less than 50.999% then colour the cell red If the value...

Hi, I wanted to know if there is any way to create a 2010 excel year planner? i.e. something that would be similar to a 2010 wall chart calendar. Thanks...

Hi, I'm reusing a worksheet with a mixture of data validation and data entry cells. The data validation is based on a list and the first cell in the list is...

Have a 2 rows of cells (5 and 6) with data. Row 5 has letters A through S. Row 6 has years 2001 through 2018. In addition, I have Cell A14 where I would like...