+ Reply to Thread
Results 1 to 7 of 7

Return data from a column that was entered in that row

  1. #1
    Registered User
    Join Date
    02-26-2016
    Location
    Canada
    MS-Off Ver
    2016
    Posts
    23

    Return data from a column that was entered in that row

    Hi all, Not sure if I'm going to be able to explain this easily. I have a vacation calendar that will have rounds of bidding.
    When I enter a name in the open columns for employee bidding it will insert a *comment in that cell as well saying who entered it, what time/date etc.
    Then the purpose is after each person has bid their round 1 of bids I have created a List Comments button in blue just to the right of the name Jimmy on the attached file. And that macro button exports all the comments to a new sheet.

    But the code I have in module 1 there references the ROW and It displays the ROW number only and I want it to reference the WK # in Column B.
    Basically -4 from the number that is displayed. I can run another line of code to reduce the number in sheet 1 D2 by 4 but there must or should be an easier way to reference the wk# in a given row.

    I hope that makes sense?? The code that needs editing is : WS.Range("D" & i) = cell.Row
    Much thanks in advance!!!

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by Doolski; 01-12-2019 at 12:25 PM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    28,857

    Re: Return data from a column that was entered in that row

    Try:

    Please Login or Register  to view this content.
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    02-26-2016
    Location
    Canada
    MS-Off Ver
    2016
    Posts
    23

    Re: Return data from a column that was entered in that row

    TMS much thanks!
    I was referencing the ROW vs Cell and see where now where I was going wrong.

    Thanks for cleaning up the code as well.
    "With WS" vs having to type WS.Range for each line. Great tip.
    Much thanks again!!

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    28,857

    Re: Return data from a column that was entered in that row

    You're welcome. Thanks for the rep.

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    28,857

    Re: Return data from a column that was entered in that row

    Note, it might be worth a little further tidy up ...

    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    02-26-2016
    Location
    Canada
    MS-Off Ver
    2016
    Posts
    23

    Re: Return data from a column that was entered in that row

    Lol, every character counts!

  7. #7
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    28,857

    Re: Return data from a column that was entered in that row

    Probably doesn't save much in this instance but, if there were more references to the Calendar sheet, it could. More to the point, if you ever change the sheet name, you only have to change it in one place.

+ 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