Macro to transfer data [Closed]

Report
-
Posts
2758
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 17, 2021
-
Hello,

I am trying to create a worksheet for stock control. When I add the quantity and items needed, as well as the job reference, signed out by and authorised by, I want to be able to be able to click ADD or REMOVE. This needs to add the quantity of items to the costing sheet, and remove the items from the total stock sheet. The remove function needs to work in reverse.

Im pretty new to this type of thing, and would appreciate any assistance that anyone can offer.

Thanks

1 reply

Posts
2758
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 17, 2021
462
Hi DHigham,

Start by creating a workbook with the appropriate sheets. Where do you put the info that needs to be added/removed? Then use a filesharing site to upload your file and post back the link.

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!