Macro to transfer data

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