I am not sure if this is even possible, but this seems to be the place to find out.
I have two sheets in a spreadsheet. Equipment and Jobs. I want to be able to create a third sheet which would allow me to take information from both of those sheets and place it into a form style sheet. I also need it to update the equipment sheet to say weather the equipment is in or out (default would be in) and what job it is at.
I've not got a lot of experience with Excel other than the basics.
Any help is always greatly appreciated.