I have an excel file that's prepared on a per customer basis. It contains what I'll call customer information (contact name, phone number, email address, etc). Below this informaiton on the same sheet, I have a section that varies in row length based on what items the customer is interested in.
I want to setup about 200+ rows on this sheet that are hidden until I paste customer items into (maybe the first row/cell before) the hidden row range. By pasting, the items spill into the once hidden rows/cells causing a percentage of them to appear...leaving the remaining of the orginally 200 hidden rows hidden.
I have spent lots of time looking for a solution, but maybe i'm not searching for the right thing...
Anyone from the Yahoo! community care to give me some advice?
2007-02-27
06:40:12
·
5 answers
·
asked by
Tony
2