macro help please

March 21, 2011 at 08:19:53
Specs: Windows XP
im making a booking system for a pizza shop.
i have a worksheet called 'place order' which has numbers in colum B, food in colum C, and prices in columD between rows 3-49
i need a macro so that when a button is clicked, if the number in columB is >0, BCD are copied onto another worksheet named 'Receipt' for that row. i also need the copied rows to form a list as this will be the receipt


See More: macro help please

Report •

March 21, 2011 at 18:36:58
Why don't you use an inventory/invoicing program rather than a spreadsheet? This more of a database application.

Report •
Related Solutions

Ask Question