LinkBack URL
About LinkBacks
i need to create a sheet in my workbook that only send inventory to a work book to keep track of rail cars unloaded ...i highlighted example of this in the screen shot. i have attatched
i need to create a sheet in my workbook that only send inventory to a work book to keep track of rail cars unloaded ...i highlighted example of this in the screen shot. i have attatched
Hi, welcome to the forum
Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum
Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
this is an example sheet of the workbook. Also All I want it to do is automatically add the railcars to the rail inventory sheet at the end of the workbook. also if anyone can think of a better way to build this sheet I would be very appreciative. I have built other spreadsheets in past but this one I am not sure of how to simplify it
It would make more sense if you could have all data in 1 sheet, but it looks like you have 2 different types of entry sheets there? (the sheet's layouts dont all see to be the same)
Could you put all data onto 1 sheet, with a heaqding/column for the silo ID?
here is an idea of how to simplify it to one sheet. but i would aslo like it to automaticaly add to the rail inventory sheet when i add railcars to the silos. and would also like to have running real time sums of each silo on the right hand side...sorry im making this so complicated.
As to the running real time sums for each silo an example of a formula for silo A would beAn adjustment would have to be made for the silos with a letter and number designation such as silo B1, in that case the formula would be
Please Login or Register to view this content.Looking at the first work book that you uploaded, John.xlsx, it seems that you are only tracking incoming BOL's to the Rail Inventory sheet, is that assumption correct?Please Login or Register to view this content.
Put this in J4, and copy to all the other cells...
=SUMIFS($G:$G,$C:$C,MID(J2,FIND(" ",J2,1)+1,99))-SUMIFS($H:$H,$C:$C,MID(J2,FIND(" ",J2,1)+1,99))
As for the rail cars, do you want to see them for every date they appear on sheet 1 - so thet you will have multiple duplcates?
JeteMC, thanks for the feedback
thank you both for the feedback ....the rail cars I just want added for end of the week and month totals just puts them in same place so make things easier...as you can see from the original sheet its not put together to make it user friendly. That works perfectly guys thank you.
and no i need the bol's railcar# date product and silo would it be easier if I put a check box in a row before the date . if that makes sense????
Can you give mer a bigger sample to work from? sheet1 only has 2 rail car entries, but sheet2 has 3, none of which match sheet 1
here it is with correct numbers . what i am looking to do is make the rail inventory sheet update when I put the data on the transload sheet. but only when i put a railcar in
Thanks for that. So, could that same patter be repeated over a few months? do you want it to update each month (last month's data gets overwritten), or just 1 long, growing list?
we will be using the spreadsheet continuous. for now I will eventually try get it switched to months at a time. but for now continuous works. thank you so much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks