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.

Try:

Please Login or Register  to view this content.

You're welcome. Thanks for the rep.

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

Please Login or Register  to view this content.

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.