Looking to insert data at location based on inputs
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.
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?
Re: Looking to insert data at location based on inputs
I may of made my request overly complicated.
I am able to get a macro to copy the info and paste it in the new cells. The part that I can not solve in properly inserting new rows at the location based on the date and shift. If anyone can guide me to get that part to work, it would be greatly appreciated.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By MarcellaB in forum Excel Programming / VBA / Macros
Last Post: 07-25-2020, 09:30 AM
By Perav in forum Excel Formulas & Functions
Last Post: 06-24-2018, 03:39 PM
By joe8904 in forum Excel Programming / VBA / Macros
Last Post: 03-14-2016, 09:51 AM
By rongil20 in forum Excel Programming / VBA / Macros
Last Post: 06-23-2015, 04:52 AM
By bkuchen in forum Excel Programming / VBA / Macros
Last Post: 07-10-2014, 11:13 AM
By ChristopherK in forum Excel General
Last Post: 02-27-2009, 02:01 PM
By email@example.com in forum Excel Programming / VBA / Macros
Last Post: 07-31-2008, 04:36 PM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1