+ Reply to Thread
Results 1 to 3 of 3

extract column data from another sheet -please edit the macro

  1. #1
    Forum Contributor
    Join Date
    02-28-2012
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    542

    extract column data from another sheet -please edit the macro

    I am not an expert in creating macros. somehow i have done a macro which is not working. kindly look into it and make necessary changes so that i can extract data from columns of another worksheet.please see the attached file.
    Attached Files Attached Files
    Last edited by sumesh56; 02-09-2020 at 01:11 PM.

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: extract column data from another sheet -please edit the macro

    Instead of doing reverse engineering with you macro (iit takes time) , it will go faster if you explain what you want to achieve ...!
    - Battle without fear gives no glory - Just try

  3. #3
    Forum Contributor
    Join Date
    02-28-2012
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    542

    Re: extract column data from another sheet -please edit the macro

    thanks for viewing my post. I am uploading new attachment. under the first sheet i have pointed out what must be done.need to lookup for value. if matches, I need to pull out data of a few columns to the first one .please see the new attachment.
    Attached Files Attached Files
    Last edited by sumesh56; 02-09-2020 at 01:40 PM.

+ 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 to edit cells across a row based on data in column 1
    By silkpantsman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-23-2019, 09:40 AM
  2. [SOLVED] Macro for extract data into new sheet
    By rchure in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-21-2017, 09:26 AM
  3. sheets lock for edit or protect sheet but macro can add data
    By sambhaji.gaikwad in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-23-2016, 11:55 PM
  4. Edit edit links macro to automate sheet selection
    By sds1126 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-07-2015, 12:27 PM
  5. [SOLVED] Need to edit the value of one cell in column J after data is pasted into another sheet.
    By Dremzy in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 05-21-2014, 12:08 PM
  6. Replies: 2
    Last Post: 10-31-2013, 01:20 AM
  7. [SOLVED] Edit Macro to Copy and Paste Data from another sheet according to date
    By rocksan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-09-2012, 02:57 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