I'm pretty good, but my buddy has a task outside of my skill set.
This thread is best viewed in "Night", no "Fairy Purple"
Kyle,
I have been very unsuccessful in attempts at my current project.
I am working in one book with three sheets. The last two sheets are blank. The third sheet is set up as an order form; the first column is used for an individual to input the quantity he/she would like to have of each item listed.
e.g.
Sheet1
Quantity_____Item____Weight _____Color
-----------_____-----_____--------_______------
____________Hat_______1lb._______Black
____________Coat______5lb._______Grey
____________Shoes_____4lb._______White
____________Belt_______.5lb_______Black
My goal is that if a quantity is entered (let’s say 10 is entered for Coats) that the entire row for coats appears as the first row in both Sheet2 and Sheet3. Then, if say the quantity 6 is entered for Belts, its entire row appears as the second row in both Sheet2 and Sheet3.
I hope I described my situation well enough!
Any help would be greatly appreciated!
Mark
This thread is best viewed in "Night", no "Fairy Purple"
Kyle,
I have been very unsuccessful in attempts at my current project.
I am working in one book with three sheets. The last two sheets are blank. The third sheet is set up as an order form; the first column is used for an individual to input the quantity he/she would like to have of each item listed.
e.g.
Sheet1
Quantity_____Item____Weight _____Color
-----------_____-----_____--------_______------
____________Hat_______1lb._______Black
____________Coat______5lb._______Grey
____________Shoes_____4lb._______White
____________Belt_______.5lb_______Black
My goal is that if a quantity is entered (let’s say 10 is entered for Coats) that the entire row for coats appears as the first row in both Sheet2 and Sheet3. Then, if say the quantity 6 is entered for Belts, its entire row appears as the second row in both Sheet2 and Sheet3.
I hope I described my situation well enough!
Any help would be greatly appreciated!
Mark