Need worksheet_change VBA code .... whenever i write "Print" in column P of everysheet except worksheet " Slips" , the respective value of column B is copied and displayed in B16 column of worksheet "Slips".
e.g like this
if targer.column = 16
if target.value = "Print" then
...........................................
Keep in mind if already value written in B16 of worksheet "Slips" then it should be deleted first then paste the respective value.
Need code whenever i pick "Print" from dropdown list of column P in worksheets , it copy respectivr value of Column B in Worksheet "Slips" cell B16.
eg
if i pick Print in p6 cell from worksheet instrument then value in B16 of worksheet "Slips" deleted and pasted the value of B6 cell of worksheet "Instrument" . and so on
if i pick Print in p13 cell from worksheet Automation then value in B16 of worksheet "Slips" deleted and pasted the value of B13 cell of worksheet "Automation" and so on
Thanks
Need code in Worksheet_Change
Bookmarks