Hi! Looking for some help or direction. Using Excel 2007. I have absolutely no prior experience in Excel Macros or VBA as my field of expertise is marketing, advertising and graphic design. I was passed over a pretty complex Excel Worksheet to see if I can make some things happen, and before I say no... I wanted to see if I can reach out for some help or try to figure it out.
The Excel Sheet is an order form that contractors use to place orders for kitchen cabinet. A drop down menu allows them to choose the style, which then displays the different cabinets and information such as pricing, dimensions, etc. that pulls the info from several hidden worksheets within the document, and the contractors can enter the quantity and it totals it up for them. My partner has figured out up to there.
What I need is 4 macro's: (1) A macro that hides all the rows where nothing was inputed in quanity to trim down the document to only what the contractor has ordered. (2) A macro that undoes the hide function. (3) A macro that hides all the rows where nothing was inputed in quanity and prints it. And finally (4) A macro that clears the form (the entries to quantity).
The Ordering portion on the excel sheet begins at B29 and goes down usually to B300. The quanity section is located in columns E & F. Any help would be greatly appreciated. Happy Holidays!!!
Bookmarks