I have two sheets Sheet1 and Sheet2. Where Sheet2 has Data and i wanted to copy the data after matching the "Quarters" from Row 6.
The row 6 would have below quarters and we will start copy the data from below quarters to end of the year (which is available in shape of like this Y2099.
Q1 2020
Q2 2020
Q3 2020
Q4 2020
If code finds that row six has "Q3 2020" this then code will start copy the Gross Wage available under the matching column. If there is one Gross Wage it will copy that one if there are multiples then code will sum and then paste it to Sheet1.
I have attached 2 sheets where i have pasted a DATA in Sheet1 Col"D" to show an example and code will paste data accordingly.
Your help will be highly appreciated.