Hello,
I'm new to macros and VBA. I am looking for a macro that will copy data from multiple sheets to one master sheet if column O has either 50% or 70% in it. There are many other sheets in the file that don't pertain to this macro. Each sheet has a person's name on it for both the ones that will be copied and the one that will have the data pasted. As the sheets with data copied are updated by multiple users I'd like the master sheet to reflect the changes as well either with a button or automatically. I really appreciate any help that is offered.
I'm new to macros and VBA. I am looking for a macro that will copy data from multiple sheets to one master sheet if column O has either 50% or 70% in it. There are many other sheets in the file that don't pertain to this macro. Each sheet has a person's name on it for both the ones that will be copied and the one that will have the data pasted. As the sheets with data copied are updated by multiple users I'd like the master sheet to reflect the changes as well either with a button or automatically. I really appreciate any help that is offered.