I have used conditional formatting before in order to change the shading of a cell based on the cell value. However, I would like to do the same except have...

Is there a way to select a range and delete hyperlinks instead of doing it one cell at a time?

I am creating a timesheet and i have inserted the first day of the month with a combo box to a linked cell A7 then in the rest of the column i add 1 to A7 then...

I have a query that imports data from an Access database, this works fine but when I import the data the headings are imported too, how do I import the data...

i cant get the OR bit right!!! i want it to check whether Cell $a$40 or $B$40 matches $S$29 then H36-$K$2 if tru and "" if false i can get it to do it for...

Can anyone help. The following code is part of a number generator, that fills a column with numbers in the format "0000" ie on 5 instances of AI, numbers 0700...

I need to develop a product/order list from an existing list in a different format. I have attached both. Is there VBA code that can do this for...

Hello I'm trying to group invoice dates in a pivot table by month and year. Too bad there is no "reason" button? heheh Any suggestions are greatly...

Is there any way to change the height of a single cell without it affecting the cells surrounding it?

I know how to convert formulas to values by copying to another sheet with Paste Special. Is there a way to change the formulas to values in place, without...

Hi all I would like to amend a column with phone numbers and change only the first two characters to a "0" Most of the numbers look like this; 44131 555...

In cell C1 I want to place a formula that will return a value of 1 if the value of cell A1 is contained in the range of cells B1:B127 and a value of 0 is the...

C. Pearson's website includes VBA code for automatically updating a Pivot table upon opening the worksheet. Does the code need to be inserted in "This...

Can someone please tell me why my text will not fit in Autofit row. It just needs to be a little bit wider. It never used to do this, is it because I'm now...

Is there a way to switch two cells around? Copy something from cell A to cell B and from B to A without using any extra empty cells. Maybe using some...

I'm trying to create a household expenses/income sheet. I'm entering the day's income and expenditure figures and totalling them at the bottom of my worksheet....

I am making a spreadsheet for my work. In this spreadsheet I enter data such as the name of a customer, additional products they may have purchased, and...

I am trying to migrate Lotus 123 (.WK4) files to Excel 2000. Macros have been rewritten in VBA, nested (if) statements rewritten so as not to be 7 levels,...

How can I make a matrix that looks like this Jan Feb Mar 95 A B C 96 D E F 97 G H I look like this 95 Jan A 95 Feb B

Dear All, An annoying problem with pivot tables, when working with users with various versions of excel. We use excel to allow end users to look at data via...