Macro to transfer data

Closed
DHigham - Aug 7, 2011 at 08:13 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 9, 2011 at 08:45 AM
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 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Aug 9, 2011 at 08:45 AM
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
0