+ Reply to Thread
Results 1 to 5 of 5

Copying data from sheet2 to sheet1 with specific requirement

  1. 11-17-2016, 12:52 PM #1
    biggener
    biggener is offline
    Registered User
    Join Date
    11-17-2016
    Location
    Mumbai
    MS-Off Ver
    2010
    Posts
    6

    Copying data from sheet2 to sheet1 with specific requirement

    I am very happy to be part of this forum, its really helpful. i am seeking help again.
    I have attached sample work book here. what i need is there are sheet 1 & sheet2. sheet1 is master file. i want to copy some specific datas into master sheet1 from Sheet2

    1) part those are OBS in sheet2 and active in sheet1 can be ignored.
    2)part those are OBS in sheet2 and not existing in sheet1need to be copied in sheet1
    3) Part those are not existing in sheet1, but existing in sheet2 need to be copied to sheet1..

    i know its very hard to do, but i m sure some expert can be helped me for sorting out it.
    really thanks for your time .\

    Please advise me how to attach excel sheet
    Test.xls
    Last edited by biggener; 11-17-2016 at 02:22 PM.
    Reply With QuoteRegister To Reply
  2. 11-17-2016, 01:00 PM #2
    Kenneth Hobson
    Kenneth Hobson is offline
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573

    Re: Copying data from sheet2 to sheet1 with specific requirement

    In a reply or Edit of a post, click the Go Advanced button in lower right. Then click the paperclip icon in toolbar or Manage Attachments link after reply box, then Browse and Upload.
    Reply With QuoteRegister To Reply
  3. 11-17-2016, 01:15 PM #3
    biggener
    biggener is offline
    Registered User
    Join Date
    11-17-2016
    Location
    Mumbai
    MS-Off Ver
    2010
    Posts
    6

    Re: Copying data from sheet2 to sheet1 with specific requirement

    as u said i have tried. But i could see only attachment options in Go Adavced. its not working
    Reply With QuoteRegister To Reply
  4. 11-17-2016, 02:09 PM #4
    Kenneth Hobson
    Kenneth Hobson is offline
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573

    Re: Copying data from sheet2 to sheet1 with specific requirement

    This forum has a problem showing the toolbar in Go Advanced. Just use the 2nd method that I explained, Manage Attachments hyperlink.
    Reply With QuoteRegister To Reply
  5. 11-17-2016, 02:23 PM #5
    biggener
    biggener is offline
    Registered User
    Join Date
    11-17-2016
    Location
    Mumbai
    MS-Off Ver
    2010
    Posts
    6

    Re: Copying data from sheet2 to sheet1 with specific requirement

    thank you so much Kenneth Hobson ,
    i hope now some body can help me for VBA
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copying data from sheet2 to sheet1
    By marius87 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-06-2016, 09:04 AM
  2. copying data from sheet1 to sheet2 automatically
    By MAHESHP030@GMAIL.COM in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-07-2013, 02:23 PM
  3. match data of sheet1 and Sheet2 ColumnA, if matched copy columnB of sheet1 to sheet2
    By annielle_09 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-25-2013, 02:58 PM
  4. Copying data returning an error in Sheet1 to next empty cell in specific column of Sheet2
    By cloudwalking in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 03-22-2013, 09:02 AM
  5. [SOLVED] Copying selective data from sheet2 to sheet1 based on the selection made in sheet1.
    By daavis in forum Excel General
    Replies: 3
    Last Post: 06-06-2012, 05:36 AM
  6. [SOLVED] Copying Data from Sheet1 to sheet2 based on criteria for copy
    By pprane in forum Excel General
    Replies: 1
    Last Post: 04-22-2012, 02:32 AM
  7. Copying Data from Sheet1 to sheet2 based on criteria for copy
    By pprane in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-22-2012, 02:07 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1