how to add a macro to ask details to insert a new product on sheets i select?

hi,
i will try to explain as clear is possible:

well, i got an excel workbook, that has many pages( 10 ).
this workbook has all my stock in diferent sheets(locations).

i will like a code, to click a button, and then to get these questions to answer:
SKU
Commodity
Product
Pack size
Quantity
Price

then, to bring another menu, with all sheets listed, so i can tick which ones i want this product to be insented.

then the macro will insert this product on the selected sheets .

Any help really appreciated !!!

anyone ??
i really need to finish this project, and i stuck

Do you want to append the data at the end or need to clear the existing data in the particular sheet you are going to select.....

Originally Posted by abduljaleel.mca

Do you want to append the data at the end or need to clear the existing data in the particular sheet you are going to select.....

hi,

i'm sending the workbook too.
i added a button on the "Master Sheet" ( but not a code )

i need the macro to collect the info i input, and then to go to the selected sheets i choose and add the product on any available blank row.

will be handy, if the sheets keep updating as well, and delete empty rows anyway.
so, if i delete a product from any sheet, then automatically will delete that row, or push up the other products.
i hope that helps
thank you in advance.
Stock Sheets V5 Full.xlsm

The file which u attached is password protected, please send this again with unprotect sheets.

Use this....

hi,

yes works great as i wanted, but how about if product has to go in 2 sheets?
do i need to add all the info again 2 times?

Yes, You need to enter all the info 2 times (type 'y' to continue 'n' to exit) for 2 sheets....

thank you for your help

Use this file....as per your personal request....

Thank you works perfect, but the "print sheets" button is not working now, but i will try to sort it out some how.

V7 only to keep new stock.xlsm

there is the new file to add when you can the 2 codes as per email.

thank you again

Try this....

you are a star !! many thanks for all your help ( Again )