Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Results 1 to 2 of 2

Thread: Insert Missing Rows From Master Data

  1. #1
    Join Date
    3rd January 2017
    Posts
    3

    Insert Missing Rows From Master Data

    Hello!

    I'm looking for a macro which will re-work a list I have an insert missing data contained in another list.

    Sheet 1 contains a list of all batches we have run on-line along with the product n.o the batch was for and all the items/ingredients used to manufacture. On sheet 2 there is a list of products along with the standard list of ingredients that we should have used to make the product. I would like for the macro to work through each batch number produced and for the product it contains check sheet 2 to see which ingredients are missing from the batch. The batch list from sheet 1 should then be copied over to sheet 3 and rows inserted for all the missing ingredients (along with the expected usage quantity).

    I've attached an example below and shown the outcome I'm looking for on sheet 3. I've only just started using macros so a bit beyond me for now.

    Any help would be greatly appreciated.

    Thanks

    List Example.xlsx

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    3rd January 2017
    Posts
    3

    Re: Insert Missing Rows From Master Data

    Just a note I've also posted this on https://www.mrexcel.com/forum/excel-...ml#post4907684. Apologies new to this and never realized that cross posting was such an issue. I'll keep the two posted updated with links if my problem gets solved on either. Thanks

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Replies: 5
    Last Post: March 31st, 2015, 21:19
  2. Insert missing rows with time and data
    By rajre in forum Excel General
    Replies: 6
    Last Post: July 28th, 2014, 17:28
  3. Replies: 10
    Last Post: September 28th, 2011, 17:37
  4. Add/Insert Missing Rows
    By moonis.ahmed in forum Excel General
    Replies: 2
    Last Post: June 18th, 2008, 19:12
  5. Append Master List If Missing Data From Another
    By nicko in forum Excel General
    Replies: 2
    Last Post: February 5th, 2008, 20:24

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
  •  
porno