Hi There, long time away from the forum.
I want a macro that takes the data in blue (PM, Region, comments etc) in sheet1 and transfer it to sheet2 to the respective field (ie comments under comments)
There maybe multiple data and do not want the data to ovewrwrite. So everytime the upload button is clicked it uploads the information from sheet 1 (the drop down menu (deactive) and the comments) and trsnfer the data to sheet2 I have a code that copies data in a row, but unable to manipulate it to pick up data that is not in a row as per this example.
Can anyone help me? I have uploaded a workbook example
Kind regards
Bookmarks