I have read similar posts in the forum but can't find a simple solution to my problem. My data is in three columns. Column B has formula which results 'Yes' or " " based on a number in corresponding cell in column A. Each cell in column B is dynamic, using a live api feed and numbers in column A to calculate. When a cell in Column B results Yes, I would like to copy and paste value of that cell into the cell to the right in column C, therefore Macro need to trigger each time when cell value in column B is 'Yes'. I need to do this for 50 sheets in one workbook, data is in the same range across all sheets. Can you please help how I can do this using VBA?