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