I have 4 worksheets. One worksheet has a listing of inventory. One has a listing of sales. One has a listing of purchases. One has a listing of audits on the inventory. I need to write a code that will update the inventory sheet when any of the other 3 are modified. Right not I am looking on getting a start. I am new to VBA and this is a little over my head.
I am using Excel 2007, but I would also like it to work in 2010. I cannot use Access to create this.
Thank you for your help.