Hi, Not sure what you mean, by default Excel handles the structure references and they automatically expand and contract as the structure of the table...

MIKE H, You are right, actually, I have set formulas into A2 and B2, In A2 , ='sheet2'!F2 , THAT MEANS THE SOURCR OF A2 IF FROM F2 OF SHEET2 In B2 ,...

I have a list in Column A of 100 values, from cell A1 to A10. Several of the cells are empty (=" "). How can I arrange Column B so that it includes in the...

If I have a list of 8 numbers and want all possible products of all 3 number combinations, how do I set this up?

Hi, After making a fool of myself earlier today, I now can direct you to the MS Works newsgroup, where you may be able to get more useful...

In my marco, I want to show a message box to ask " do you have open the 1244.xls file" and to show two button " yes" and "no" for user select. If user select...

ive lost some work....properties show the info is still there anyone any ideas?thx

Greeting, I have two columns, E&D. E has a material number and D has the size. There is more than one size for one material. What I want to do is count the...

Cells A1:F1 consists of headings: Class-I; Class-II; Class-III; Class-IV; Class-V; Class-VI; Cells A2:F13 consists unit price of every Class during each of...

Greetings, I seem to have lost the ability to cut and paste worksheet cells. I can highlight the chosen cells and use ctrl C to put them on the clipboard,...

Hi all, Is there a way to convert this date string OCT 23'08 6:04PM into serial that Excel will recognize as a number instead of a string? Thanks! goss

I have a master Worksheet which collects data from workbooks I distribute to others. When I get them back filled in, I put them in the same folder with the...

If I click fx button in Excel I can bring up the section of UDF functions. Is there a way I can add help to my UDF so that the user can get help on the...

I need a format that omits all of the characters before a hyphen (-) and one after it. example; 001- ABC displayed as ABC I can easily do this with a formula...

I have heard that you can design a quilt using excel. Does anyone know how to do this?

I often code cells to check for error - something like =IF(ISERROR(VBLOOKUP(parms........)),"",VBLOOKUP(parms.........)) but I'd like to try to write a...

How to find inverse of complementary error and error function

How do I set up alternate excel row spacing like 9, 20, 9 pixels?

I have an Array of 4 columns A1:D1000. First column consists of formulas which either result to a string or "". How to insert a Vlookup() formula to checkout...

I'm using Excel 2002, and have a file I want to be able to read on a machine that only has MS Works (not sure of the version). What's the best way of doing...