Results 1 to 7 of 7

Match existing column name, copy based based on matching name, drag till end

Threaded View

  1. #1
    Registered User
    Join Date
    06-20-2012
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    44

    Post Match existing column name, copy based based on matching name, drag till end

    Hi Experts...

    I have data set which is driven by a condition. The driving condition is month, based on the month in A1, the data from B1 to B20 to be copied and pasted as value in sheet 2.

    Sheet 2 have Months defined as column headers (A1 to X1). There is a blank column between two months. The function should match the month specified in Sheet1 A1 to Sheet 2, copy data B1 to B20 right under the matching criteria header. It should get updated for month specified in condition till months till year end...

    Please help..

    Sample file attached
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy column based on partial word match in first row and paste into existing workbook
    By David Harris 1987 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-19-2013, 03:52 PM
  2. Copy column based on partial word match in first row and paste into existing workbook
    By David Harris 1987 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-11-2013, 01:02 PM
  3. [SOLVED] Identify the last filled row in Column A and then drag formula in Column B till the same
    By bonny24tycoon in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-13-2012, 10:50 AM
  4. Replies: 1
    Last Post: 07-01-2011, 07:21 PM
  5. Replies: 2
    Last Post: 03-16-2009, 12:26 PM

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