Microsoft Office Questions? Ask a IT Expert for Support ASAP
Ok. Thank you. I'll upload the file now. There are 3 worksheets within the file. Pricelist, Lanlogic View, Proposal View. I need the blank rows in the Lanlogic View and Proposal View worksheets hidden after populated.
The file ID is 962594
The Pricelist tab is the input worksheet. Then the LL view & proposal view sheets get automatically populated. So you put a 1 in any of the rows under qty that row should show up on the following 2 worksheets.
After the user inputs all the qty's they need, you'll notice blank rows in between for all the items they didn't put a qty amount for. I need those rows hidden.
WOW!!!! That was awesome! There's only one glitch. When I hit hide rows, the rows with the titles of each section went away also.
So for example if any item under Systems Hardware had a qty listed for it, the title Systems Hardware would show up. (Note, an amt would not be inputted in the qty column for the title rows). So I need those to stay. Is there a way to make that quick fix?
Oh sorry. If you look on the Pricelist/input sheet all of the titles are in Bold. So for example System Hardware is row 19 and Mass Storage Hardware is row 27, etc.
If you play with it and put a qty amt for any of the items listed under the titles you'll see those titles as well as that item show up on the other 2 sheets.
So on the pricelist sheet System Hardware is in B19. In the Proposal View sheet is in B21.
If the title is centered it is a main title for a group of subtitles that are also in Bold but left aligned.
So for example if you put a qty in A49 for "S Series...." then the titles System Hardware & Scale will show up.
I guess I should state product group titles instead of headers.