Cross sheet column subtraction
I have two sheets where I am tracking inventory, one sheet contains data for material available, and the other for material used, given that not everyone has access to all sheets and I want to create a report where I can display the material available ( basically the difference), Is there a way to do a cross sheet column subtraction without linking cells? and even if i have to link cells can I link an entire column so that it auto updates whenever someone updates and adds a row?
Help Article Resources
Check out the Formula Handbook template!