Job Tracking Sheet

billtakesphotos · Oct 2nd 2016

Hey,

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.

**alansidman** · Oct 2nd 2016

Re: Job Tracking Sheet

I suggest that you upload your current workbook with sample data. Make sure that there is enough data to be representative of all your data. Create a third sheet in the workbook manually, that will look like your expected results. The information you have already provided does not present enough information to provide a solution. To upload a spreadsheet, click on the Go Advanced button in the reply screen. Scroll down to manage attachments and follow the wizard.

crysmarye · Oct 15th 2016

Re: Job Tracking Sheet

what is the shortcut of insert date into excel

**S O** · Oct 15th 2016

Re: Job Tracking Sheet

[h]*[/h]

Job Tracking Sheet

Participate now!

Share