Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Help. Please read...
I have a price list on excel, it comprises of the columns: Part Number Description Cost (What the business pays) Price (What the business charges) Quantity I need however to make some sort of macro so that when a user come along to create a quotation and puts in some quantities of variou products, a button perhaps is pressed and that selects all the item that have a quantity against them and takes the Part Number Description and Price of those items onto another page in th workbook. For instance. (Sheet one) Part No......Description....Cost....Price....Quantity 45854.......Sweep Tee......2.5.......3.5.........1 45855.......Pipe Bend........1.5.......4.5.........3 45856.......Galv Pipe.........1.0.......1.5 45857.......Galv Socket.....5.0.......6.5 45859.......Medium Tube...4.5......6.0..........4 45860.......Hollow Plug.....1.75....2.5 45861.......M/F Bend........2.0......4.5..........2 45862.......F Elbow..........2.5......3.5 45863.......Galv Cap........3.5......5.0...........3 Then perhaps a button with a macro attached to it. Which, when pressed, creates this on another sheet. (Sheet 2) Part No....Description.......Price.....Quantity 45854......Sweep Tee.........3.5...........1 45855......Pipe Bend...........4.5...........3 45859......Medium Tube.......6.0...........4 45861......M/F Bend............4.5...........2 45863......Galv Cap............5.0...........3 ..........................Total:.....£23.5......13 Items (Note: This is not the actual table I need to do this with, there ar about 150 items) So I need the macro to take all the rows with quantities and leave al the rows that no quantity was specified. To create like a quote/reciep kind of document. It looks oh so simple, but this really is haunting me. :( I would be very grateful if you can help me with this, no pressure, bu my job is on the line! lol (No really, it is) Any help would be wonderful. Thanks for your time. Laura x (My email address is ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Read Only If Statement | Excel Discussion (Misc queries) | |||
Help getting macro to work in read only | Excel Discussion (Misc queries) | |||
Cant find Macro in read only | Excel Discussion (Misc queries) | |||
Force read-only in auto_open macro | Excel Discussion (Misc queries) | |||
macro to read from Project | Excel Programming |