+ Reply to Thread
Results 1 to 2 of 2

Looking to insert data at location based on inputs

  1. #1
    Registered User
    Join Date
    05-14-2018
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    12

    Question Looking to insert data at location based on inputs

    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!

  2. #2
    Registered User
    Join Date
    05-14-2018
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    12

    Re: Looking to insert data at location based on inputs

    Hi All,

    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.

    thank you,

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Auto-Populate a row based on data input in another row and associated cell inputs
    By MarcellaB in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-25-2020, 09:30 AM
  2. [SOLVED] Extracting data between two dates based on three inputs
    By Perav in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-24-2018, 03:39 PM
  3. [SOLVED] Loop through checkbox and inputs data based on which is checked
    By joe8904 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-14-2016, 09:51 AM
  4. Copy data into a new workbook based on inputs
    By rongil20 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-23-2015, 04:52 AM
  5. Help with macro to pull data based on certain inputs
    By bkuchen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-10-2014, 11:13 AM
  6. Replies: 2
    Last Post: 02-27-2009, 02:01 PM
  7. Insert Rows Based on Location
    By hutch@edge.net in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-31-2008, 04:36 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1