+ Reply to Thread
Results 1 to 5 of 5

Multiple Cell Values Transfered by Macros!

  1. #1
    Registered User
    Join Date
    11-14-2011
    Location
    England,North East
    MS-Off Ver
    Excel 2003
    Posts
    67

    Multiple Cell Values Transfered by Macros!

    I need a macro that will check a cell within a column, if that cell has a value I need it to pull back the column header and then individual job codes from the same column and hours worked from a separate column (multiple cells) into multiple cells on the target sheet and continue doing this until it has exhausted input in the initial column at which point I need it to move onto the next column and do the same thing.

    Is this even possible and does anyone have any suggestions.

  2. #2
    Forum Contributor
    Join Date
    11-04-2011
    Location
    pak
    MS-Off Ver
    Excel 2007
    Posts
    132

    Re: Multiple Cell Values Transfered by Macros!

    hi Michel
    u need to upload sample workbook

  3. #3
    Registered User
    Join Date
    11-14-2011
    Location
    England,North East
    MS-Off Ver
    Excel 2003
    Posts
    67

    Red face Re: Multiple Cell Values Transfered by Macros!

    Hi Shaukat,

    I have attached a workbook with some comments about what I am trying to achieve. Any hint on where I need to start would be much appreciated.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    11-14-2011
    Location
    England,North East
    MS-Off Ver
    Excel 2003
    Posts
    67

    Re: Multiple Cell Values Transfered by Macros!

    I'm bumping because I'm going rapidly grey, trying to figure this out! Any help gratefully received.

  5. #5
    Forum Contributor
    Join Date
    11-04-2011
    Location
    pak
    MS-Off Ver
    Excel 2007
    Posts
    132

    Re: Multiple Cell Values Transfered by Macros!

    and where from hours are picked?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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