"calculate" appears at the bottom of my worksheet. It seems to be some type of circular reference and some of my formulas are not being calculated, even when...

I have a workbook containing several sheets. In one of them there's a list of organizational units. I've written a macro that grabs selected unit identifiers...

Is it possible to use a macro to format Excel? I have a number of sets of data under headings e.g. Heading1 Data 1 Data 2 Data 3 Data 1 Data 2 Data...

How do I keep Excel from truncating leading zeros in cells? For example how do I keep 0000304 from becoming 304?

I have a spreadsheet that is shared and someone has dragged up so high you can't get a hold of it to drag it back down to make it all visionable. Any ideas on...

I have a master sheet of workers names, the names are in the A column. in the B colm i want a formula that will go thru department sheets and find the name in...

I have a rather large spreadsheet and need to reduce the file size. I have compressed the pictures in the file, but the size is not getting any smaller. It...

I want to download some data from the web which is in a simple table format (7 columns x 50 rows). I use MS Web Query to do this. Is there anyway that I can...

Please advise how I can convert a number that comes over as '40593 from our Italian firm. How do I take the ' off of the number. I have 3000 rows of numbers...

I've got a customer that has a bunch of paragraphs within cells. She is using the Find/Replace option, to search for a particular word. She finds 5 instances...

I need the last number in the cell to be sent to Sheet2 B1. For example, Sheet1 column G is always counting down in Column G. How do I send the last entry in...

Hello, I have a user that is trying to insert a row on one of four sheets in one excel file. On the first one he cannot insert a row but on the other...

Again, I've looked and looked under MS Excel help and on the web. I think I'm again not asking the right question as nothing comes up. How can we restrict...

Hello, I have a column with names in it. The names are in lower case. I want to change all letter in the name to capital letters. How can I do this without...

I have an array that I need to reverse. What is the easiest way to do this? (A1 = X, B1 = Y, C1 = Z and I want to have A2 = Z, B2 = Y, C2 = Z)? Was hoping...

Can anyone come up with a reason why a vlookup would not work ?? I have part numbers and sales category on one workbook. I have part numbers and prices on...

Hi I have 1200 lines of text and numbers in the form below Gross Sales 1200 1500 2400 1100 Garden 40 50 65 ...

Hi, I wish to email just a single sheet, or even better a selected / specified area of that single sheet, automatically when the user presses a button,...

Hey. I have a worksheet with a column of data (D8:D58). Currently, the last data entry occurs in cell D43. I am interested in retrieving the last piece of...

How can I remove columns that contain all zeros? Is there a macro? I craeted a sumif formula to flag columns subtotaling zero but I need a method to remove...