Hi there,
I've found a number of threads that deal with a similar question but none exactly the same so bear with me! Also new to this forum so I may not explain myself 100% but really appreciate all the help!!
I have a large table of data on Sheet "Quote Register" The data input fields are C:AC (Columns A:B are formulas and need to stay this way)
At the moment the data in the last row is flowing through from another workbook. I have it set up so there are formulas in rows below but data only appears once in the last row. eg. there are formulas to pick up the data from another sheet in rows 210-2000. Data only appears in row 210 and data from row 1-209 is hardcoded.
In Row AC there is a formula which says "Yes" when all data has been entered correctly in the Quote Register sheet.
What I want the macro to do is identify all rows with "Yes" in AC and copy and paste values.
The macro should only be activated when the button is hit (Im comfortable with creating a button and assigning the macro)
I've found a number of threads that deal with a similar question but none exactly the same so bear with me! Also new to this forum so I may not explain myself 100% but really appreciate all the help!!
I have a large table of data on Sheet "Quote Register" The data input fields are C:AC (Columns A:B are formulas and need to stay this way)
At the moment the data in the last row is flowing through from another workbook. I have it set up so there are formulas in rows below but data only appears once in the last row. eg. there are formulas to pick up the data from another sheet in rows 210-2000. Data only appears in row 210 and data from row 1-209 is hardcoded.
In Row AC there is a formula which says "Yes" when all data has been entered correctly in the Quote Register sheet.
What I want the macro to do is identify all rows with "Yes" in AC and copy and paste values.
The macro should only be activated when the button is hit (Im comfortable with creating a button and assigning the macro)
