Small Excel Project - To help make my new job easier.

Hello guys,

Hope you are all OK, I am looking for a little bit of help with a small Excel project to help make a my new job easier / quicker. I already have tons of work on my plate, so I am trying to find a way to speed things up in an accurate way.
I do an Admin / Stock Control job, and part of my job is to (Upload) data from Excel into our warehouse management system. (Red Prairie).

Each day I am given between 20-30 of something called a "Blind Check", which is a physical count of Pallets that have been unloaded from a trailer.

an example of a Blind Check will have the following information.

SKU , CASES , MANUFACTUING DATE, QUANTITY


FT117 / 10 / 03/08/2017 / 5
FT227 / 20 / 03/08/2017 / 20
FT337 / 30 / 03/08/2017 / 7


Example Total - 32 Pallets

sku - Product Name
Cases- How Many On a Pallet
manufacturing date - production date
quantity - how many pallets of that sku their is.

Each SKU (will / should) always have the same amount of cases on the pallet so this number will more than likely be the same and same goes for the manufacturing date.

Previously before my small project, I was required to type up the data separately from the blind check (in the above example) I would have separate 32 lines. i.e

FT117 / 10 / 03/08/2017
FT117 / 10 / 03/08/2017
FT117 / 10 / 03/08/2017
FT117 / 10 / 03/08/2017
FT117 / 10 / 03/08/2017
FT227 / 20 / 03/08/2017
FT227 / 20 / 03/08/2017
FT227 / 20 / 03/08/2017
* and so on*

I have created a project now where all I require is to do is type how many of each sku I need for it to display line by line so I can copy and paste this over to the Upload sheet for the WMS. (to which I have attached). This seems to have speeded things up a lot and I am trying to improve it. It gives me a total of how many pallets I have just to ensure its accuracy.

What I am trying to do next is add some buttons and protect the "formula" cells so these cannot be edited.

So I guess, what I need to do next is.

1. Add a clear button to clear my form (selected cells) *these cells stay the same*
2. Add a copy button ( to copy selected cells) *bearing in mind these cells change*
3. Protect the formula cells so they cannot be accidently changed - *by user error*

And if anybody has any feedback to if I can do this any other way to which may be helpful I would greatly appreciate it.

Thank you for everybody's help. Much appreciated.

Craig

You will need VBA for this - I'll move the thread to that section for you.

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)