Hi all!
I'm working on a shared tracker with Contact details, dates and more information and it gets updated every day from different people and every time they update or input new data, they are obligated to change its font to red.
When I see the new updates, I consolidate this information into a Master file and I have to go Filter by filter and select the cells with red font to manually copy and paste the data into the file based on a unique number.
Is there an easier way to do this with a VBA code?
It would be nice to have a loop to choose the red value and paste it into the master file matching the unique number. Makes sense?
I'm working on a shared tracker with Contact details, dates and more information and it gets updated every day from different people and every time they update or input new data, they are obligated to change its font to red.
When I see the new updates, I consolidate this information into a Master file and I have to go Filter by filter and select the cells with red font to manually copy and paste the data into the file based on a unique number.
Is there an easier way to do this with a VBA code?
It would be nice to have a loop to choose the red value and paste it into the master file matching the unique number. Makes sense?
