+ Reply to Thread
Results 1 to 3 of 3

copy sheet 2 data as it is in sheet3 if column "B" matches in sheet1 & Sheet2

  1. #1
    Registered User
    Join Date
    06-15-2015
    Location
    india
    MS-Off Ver
    2007
    Posts
    2

    copy sheet 2 data as it is in sheet3 if column "B" matches in sheet1 & Sheet2

    Sheet1
    A & |B|

    Sheet2
    A & |B| & C

    sheet3

    A & B & C


    copy sheet 2 data as it is in sheet3 if column "B" matches in sheet1 & Sheet2
    Note here i will enter duplicate values it column "B" in sheet1 & Sheet2

    so it should not copy again n again in sheet3 it should copy only once.


    Project flow:-

    1] Enter the Items like Egg,Eggs, Steak,Lamb Steak,Tenderlion,Porterhouse, Steak & Eggs
    in column B2 hit Tab it will give Egg Mod in column "J"
    2] As soon as its shows Egg Mod in column "J"
    3] Sheet2 show show data from A2 to C7
    ------------------------------------------------
    1] Same goes with steak mode
    Enter the Items like Steak,Lamb Steak,Tenderlion,Porterhouse, Steak & Eggs
    in column B2 hit Tab it will give Steak Mod in column "J"
    2] As soon as its shows Steak Mod in column "J"
    3] Sheet2 show show data from A8 to C13
    ----------------------------------------------

    Now catch column in sheet2 are not fixed so if there is another information
    it should paste below that columns

    ----------------------------------------------
    Also run my project (Macro) and let me know where i am wrong and where can i improve
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: copy sheet 2 data as it is in sheet3 if column "B" matches in sheet1 & Sheet2

    asking for help and protect with password, clever


    Kind regards
    Leo

  3. #3
    Registered User
    Join Date
    06-15-2015
    Location
    india
    MS-Off Ver
    2007
    Posts
    2

    Re: copy sheet 2 data as it is in sheet3 if column "B" matches in sheet1 & Sheet2

    oh i am so sorry passwrod is w3lc0me@

+ 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] If there is any text in column "A$" on "sheet1" then move cell to column "A$" on "sheet2"
    By ckgeary in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-27-2013, 08:28 PM
  2. [SOLVED] Copy Range of data from sheet1 and sheet2 paste it in sheet3
    By hassan khansa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-18-2013, 05:55 AM
  3. Copy Range of data from sheet1 and sheet2 paste it in sheet3
    By hassan khansa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-18-2013, 05:47 AM
  4. [SOLVED] copy and paste from sheet1 and sheet2 to sheet3 and loop
    By sagroy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-07-2013, 02:04 PM
  5. Replies: 0
    Last Post: 10-09-2012, 08:46 PM
  6. Copy column from sheet2 if specific cell in sheet1 is "QLD"
    By matrixpom in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-09-2012, 04:57 PM
  7. [SOLVED] comparing data in column [sheet1] with data in column [sheet2] and execute "yes" or "no"
    By dragon_m0nsta in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-14-2012, 03:27 AM
  8. How to copy some columns from sheet1 to sheet2 or sheet3
    By wlarson in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-30-2007, 08:58 AM

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