+ Reply to Thread
Results 1 to 2 of 2

Copy certain items automatically from one sheet to another

  1. #1
    Registered User
    Join Date
    04-10-2013
    Location
    Singapore
    MS-Off Ver
    2010
    Posts
    23

    Copy certain items automatically from one sheet to another

    Hi,

    I hope someone could help me with this - I want to be able to copy some items from sheet 1 to sheet 2 without losing the values of a certain field. When I do a simple vlookup, the value of a certain field copies only one type. Please see attached file for more details.


    Thank you in advance!
    Attached Files Attached Files

  2. #2
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Copy certain items automatically from one sheet to another

    A2:
    =IFERROR(INDEX(Sheet1!A$2:A$13,SMALL(IF(Sheet1!$G$2:$G$13="delivered",ROW(Sheet1!$G$2:$G$13)-ROW(Sheet1!$G$2)+1),ROWS(Sheet1!$A$2:A2))),"")
    Confirm COntrol+shift+Enter
    Drag down and accross

+ 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. Formula to insert serial numbers automatically to an excel sheet with diff. items
    By saranorton in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-16-2015, 09:20 PM
  2. [SOLVED] How to Automatically Copy New Data into the next sheet and have it automatically sorted??
    By ReedDOT in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-24-2013, 10:50 AM
  3. Replies: 4
    Last Post: 10-12-2012, 01:36 AM
  4. Replies: 2
    Last Post: 10-11-2012, 08:53 AM
  5. Macro to Look for Sheet, create if none, sort items from master & copy to new sheet.
    By ali.whitaker in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-25-2012, 12:58 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