$$Excel-Macros$$ Subtotal needs tweeking

Is there a quick way to turn subtotaled data into permanent values, without keeping the supporting numbers in the spreadsheet? I'm subtotaling an inventory of products, and once I get the totaled values and collapse the tree down to '2', I need to transfer the end result to another worksheet or des

Re: $$Excel-Macros$$ Validation rule and 'X'

Hi Dave, The first solution was exactly what I needed. Works great. Now, is is possible to have more than one validation rule per cell, perhaps by creating an array in the Formula box under Validation / Settings? Hane -- --

$$Excel-Macros$$ Validation rule and 'X'

I have a list of products containing combinations of letters and numbers. I want to create a validation rule under 'Custom' which runs when a product containing the letter X is typed. how would I express this in the formula? Thanks in advance. Hane --