+ Reply to Thread
Results 1 to 4 of 4

Move data from list 1 to list 2

  1. #1
    Registered User
    Join Date
    01-24-2019
    Location
    Poland
    MS-Off Ver
    2019
    Posts
    19

    Move data from list 1 to list 2

    Hello
    How to move data from list 1 to list 2.
    I need to move from list 1 name and quantity of items to list 2 automatically. How to do this? The Hood should be counted as Oven. And FYI the list1 is not always the same so the quantity of the lines are changing form time to time. I already filed one field manually in list 2.
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Move data from list 1 to list 2

    If you mean you want to physically move data from 1 location to anotrher (so that it no longer appears in teh 1st location) you cant do that with formulas, you will need VBA (code)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    01-24-2019
    Location
    Poland
    MS-Off Ver
    2019
    Posts
    19

    Re: Move data from list 1 to list 2

    Maybe not move but transfer. Data in first file should stay.

  4. #4
    Registered User
    Join Date
    01-24-2019
    Location
    Poland
    MS-Off Ver
    2019
    Posts
    19

    Re: Move data from list 1 to list 2

    If you need I can merge two files in one file maybe it would be easier?

+ 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] Move data to next empty in list on sheet 2
    By HereComesTheBoom in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-31-2018, 10:19 AM
  2. button click to move selected multi-column list box items to new list box
    By kranic3 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-14-2017, 08:34 AM
  3. Replies: 3
    Last Post: 04-22-2014, 03:30 PM
  4. Replies: 0
    Last Post: 01-09-2013, 11:44 AM
  5. Replies: 3
    Last Post: 07-20-2012, 09:52 AM
  6. Move and sort list of data to another sheet
    By Ramachandran in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-04-2012, 05:15 AM
  7. Data in list w/same A:B move to column
    By Adresmith in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-24-2006, 05:00 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