+ Reply to Thread
Results 1 to 1 of 1

Extracting Data from 2 sheets & Placing in other 2 sheets of same workbook using VBA Macro

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2010

    Extracting Data from 2 sheets & Placing in other 2 sheets of same workbook using VBA Macro

    Dear All,

    I have Two Worksheets in a work book (link of workbook provided for reference), Named "Main Template" and "SampleSheet for Main Template".

    Data and format of data in Column A, B, D & F of "Main Template" and "SampleSheet for Main Template" are constants and already filled.

    Data in Column (I & L) is to be filled manually in "Main Template" if there is any observation found in selected samples. Moreover "No" is to be manually entered in columns "M, N, O, P & Q" of "Main Template" for the list of those samples who bears the audit findings.

    For instance an audit finding entered in column "I" against sample No. 1 & 3. Now in column M & O, "No" will be manually input.

    Macro should work based on data in above said two sheets in following manner:-

    Read data from column "I" of "Main Template", and if it is filled then pick data of that row for columns "D, F, I, K, L" and place it in "Outcome Main" Sheet.

    Additionally it should assign and Annexure No. like "1" for first audit finding and 2 for second and so on.

    Then this macro should fill sample details with same annexure reference in sheet "outcome Annexure to Main" by picking data from "SampleSheet for Main Template".

    Data yellow marked in last two sheets is required output.

    File is attached for working.
    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)


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