Good day,

I'm in charge of several large inventory of medical equipment and I'm looking to make my job easier using excel VBA.

I have created a small version of the spreadsheet I'll be using to post here.

Inventory Test.xls

The main sheet is called "MEDIC 1" this is where I do most of my work.

When I enter data in the "Avail Qty" Column, it updates the Qty on Order Column.

What I would want to do is that when a value other than 0 appears in Qty on Order, It automatically selects data in the column A-B-C-E-G-T and pastes it in the proper column on the order sheet, with borders.

The main goal is that I just need to update the available qty, switch to the order sheet, hit print and I have my order ready.

I've searched for some times, but I don't know enough about VBA to adapt what I've found for my application.

Thanks

The Cdn Medic