Hello All,
I have a schedule made for the next 6 months for each shift, and what parts they have to count on their shift. Things change every week and I want to add a new part to count on a certain day, and a certain shift.
I want to have 2 search inputs, -the date and shift, & 2 data inputs- a box for the new part number and the warehouse. By pressing a button, it should search for that date, then shift, and insert some blank lines to enter the part and warehouse.
insertcell1.JPG
insertcell2.JPG
insertcell3.JPG
I have attached 3 photos to show what I want to happen.
1st photo you can see the list, and the data i want to import on the right
2nd photo is showing the cells i want to insert blank lines at
3rd photo shows where the data i entered will be placed. (Part name is entered with an index match and warehouse colour changed by conditional formatting)
I have tried many different macros online and tried to edit them to my needs but cant get them to insert the blank cells at the locations I want based on the information in the cells.
One of the solutions i tried was instead of the criteria being entered in a cell, it had pop up windows for you to enter the data. i am not apposed to their approach either.
Anyone able to lead me in the right direction?
thank you!
Bookmarks