+ Reply to Thread
Results 1 to 1 of 1

Macro to copy row values based on a identical column headers

  1. #1
    Registered User
    Join Date
    02-25-2013
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    1

    Post Macro to copy row values based on a identical column headers

    I am pretty new to VBA/Macros. Here is my requirement looking for a solution. I would require a macro, which identifies the row values by Column heading and returns those cell values in another worksheet with the same column headers on the same workbook. These columns are at different ranges on two worksheets and has the cell values starting at different ranges. For example, I have a workbook, with worksheets Summary (Sheet1) and January (Sheet2), I need four columns from Sheet2 (January) starting from Column No. 22 to 25 & rows values in the cells are starting at row 4 and onwards, macro should run to exclude the headers from this sheet and return the values under these columns to Sheet 1(Summary)with the same column headers ranging from column no. 10 to 13 and cell values should begin from row 18 onwards. Hope you have a clear picture of my requirment. Please ask me for any additional questions. Thanks for your help in advance. Please see the attached sample workbook for your reference.

    Cross Post URL:
    http://www.ozgrid.com/forum/showthread.php?t=175523
    http://www.mrexcel.com/forum/excel-q...n-headers.html
    Attached Files Attached Files
    Last edited by Vijaya Pratap; 02-25-2013 at 08:11 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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