Hi guys, i'm wondering how can i transfer data from sheet1 and cell (let's say A1) to sheet2 in cell (let's say B7) if i change the fontcolor of A1. The color of fonts is set to auto for all data.


Thanks in advance
Excel Worksheet.xlsx