Transfer of data

micpirie

New Member
Joined
Apr 2, 2014
Messages
6
Hi All

Hopefully someone can point me in the right direction with this problem.

We are trying to get away from having paper copies and go digital with batch cards at my work.
At the end of each week we print out a weeks worth of batch cards, the operators use the cards for recording temperatures at certain times of the day, the cards then follow the product all the way from start to finish.
We have 48 vessels all at different stages of production which continually fill and empty throughout the day so the operators are constantly filling in the batch cards.


I have made up worksheets with all the information that the operators need for their work, but I am struggling on how to transfer the information from the control sheet to individual batch cards.

Is there any way that once the sequence starts the operator just needs to enter the batch number onto the batch card, this would then look at the control worksheet and pull up all the information that is required to fill in the card, for example the profile that the sequence requires the time that the profile started and the date.

This information is all held on the control sheet so would be on the same row as the batch number, there is more information on the control sheet that is not required for the batch card so it would only have to transfer certain cells to the appropriate columns on the batch card.

Our process is a continues operation with a 30 tonne batch starting every 2 hours then taking 8 days to complete so its not long before we have a pile of paper lying around in store cupboards.

Thank you for your help
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
I'd suggest you want a single worksheet or database containing all of your data, and then control the way in which data is added to or extracted from that database. You then have some kind of Form, probably involving some VBA, that is set up for your needs

MS Access would be a good way to go with this too
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top