+ Reply to Thread
Results 1 to 2 of 2

Help to create macro for copying data from one sheet to another sheet of same workbook

  1. #1
    Registered User
    Join Date
    10-18-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    1

    Help to create macro for copying data from one sheet to another sheet of same workbook

    Hi,
    Can someone help with macro for copying data from one sheet to another sheet of same workbook.
    The workbook sample attached herewith has four worksheet 1) screen 2) main 3) Entry 4) Error, The marco will run from screen sheet . when its run the macro should copy the data on “Entry” sheet find on the “Main” sheet then paste. If the data is not found on “Main” sheet then it should paste on “Error” sheet. This is the outline.

    Program requirement steps

    1) Macro run from Screen sheet
    2) Go to entry sheet. Take data of F & G column ( As F and G has duplication data only combination search can find exact match) come to Main screen to find the match.

    a.)If match is found then check Column I is empty
    i)if empty then paste data of Sheet “Entry” H /I / J column on “Main” sheet I /J/K column
    ii)If not empty then look for the next match and check Column I is empty
    b.) if no match is found then go to “Error” Sheet paste “Entry” sheet Colume A to J on the empty row from top.

    3) The program should check this for row till end row ( lets assume 1000 or 1500 till data is there) of “Entry” sheet.

    Thx in advance for your support
    Regards
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-23-2005
    Location
    Rome
    MS-Off Ver
    Ms Office 2016
    Posts
    1,628

    Re: Help to create macro for copying data from one sheet to another sheet of same workboo

    See the macro in attached file, I hope that it's what you need.

    Regards,
    Antonio
    Attached Files Attached Files

+ 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. Macro: Create an input sheet an copy the data onto a new row in another sheet
    By bernardnoel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-17-2013, 09:23 AM
  2. Macro help in copying data from multiple sheets to first Sheet of workbook based on condn
    By archies.gall in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-26-2013, 02:47 PM
  3. Replies: 8
    Last Post: 12-14-2012, 05:33 AM
  4. [SOLVED] Macro for copying data from one column in sheet 2 based on two criterias in sheet 1
    By baardings in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-13-2012, 01:50 PM
  5. How to create Macro For 100 sheet data into one master sheet
    By datta9381 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-24-2012, 04:59 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