I want to fill in a spreadsheet (Sheet A), based on another sheet with data (Sheet B).
However, I need it to look for several items at a time on Sheet B and consolidate the totals before entering into sheet A.
So, on Sheet B, I have a bunch of data - Carrier, Date, Crew, and a breakdown of charges for trucking standby, etc.
On Sheet A, I have a formatted spreadsheet that shows the number of specific charges, based on Date and Crew # (there can be several Carriers on a Crew)
How can I easily enter data into Sheet B and have it populate (and sometimes sum) the number of charges per date & crew afterwards.
Here is Sheet A:
I need a formula/way to look on Sheet B and look at the Charge type (Chainups, etc), the Crew # (Crew 2 in this instance), and the Date and provide the number of chainups from Column E on Sheet B, into the space here on Sheet A for the Date of June 25.
There may also be multiple carriers on Crew 2, so can I have it sum all applicable charges before entering into Sheet A?
[/URL][/IMG]
Here is Sheet B with Data.
[/URL][/IMG]
I am open to reformatting either spreadsheet to make something like this work - just needs to be easily readable for Clients.
A copy of the Document can be found HERE
Thanks!
Autumn
However, I need it to look for several items at a time on Sheet B and consolidate the totals before entering into sheet A.
So, on Sheet B, I have a bunch of data - Carrier, Date, Crew, and a breakdown of charges for trucking standby, etc.
On Sheet A, I have a formatted spreadsheet that shows the number of specific charges, based on Date and Crew # (there can be several Carriers on a Crew)
How can I easily enter data into Sheet B and have it populate (and sometimes sum) the number of charges per date & crew afterwards.
Here is Sheet A:
I need a formula/way to look on Sheet B and look at the Charge type (Chainups, etc), the Crew # (Crew 2 in this instance), and the Date and provide the number of chainups from Column E on Sheet B, into the space here on Sheet A for the Date of June 25.
There may also be multiple carriers on Crew 2, so can I have it sum all applicable charges before entering into Sheet A?
![StandbyDetails.png](/board/proxy.php?image=http%3A%2F%2F%5BURL%3D%22http%3A%2F%2Fs170.photobucket.com%2Fuser%2Flibrafrompluto%2Fmedia%2FStandbyDetails.png.html%22%5D%5BIMG%5Dhttp%3A%2F%2Fi170.photobucket.com%2Falbums%2Fu267%2Flibrafrompluto%2FStandbyDetails.png&hash=0f9fc9ab41a6ee76663deb3b3cbe8074)
Here is Sheet B with Data.
![StandbyDetails.png](/board/proxy.php?image=http%3A%2F%2F%5BURL%3D%22http%3A%2F%2Fs170.photobucket.com%2Fuser%2Flibrafrompluto%2Fmedia%2FStandbyDetails.png.html%22%5D%5BIMG%5Dhttp%3A%2F%2Fi170.photobucket.com%2Falbums%2Fu267%2Flibrafrompluto%2FStandbyDetails.png&hash=0f9fc9ab41a6ee76663deb3b3cbe8074)
I am open to reformatting either spreadsheet to make something like this work - just needs to be easily readable for Clients.
A copy of the Document can be found HERE
Thanks!
Autumn