Good Morning
I am after a formula/macro that will copy a row of data if two certain cells match.
In sheet 25 (Called 'All Orders') I have headings in the columns A-O. The headings are in row 2 and the data starts in row 3.
Sheet 26 (Called 'Wolds') is set out in the exact same lay out.
What I need to do is; If Column E in 'All Orders' matches the text in cell A1 in 'Wolds' then copy the row of information from 'All Orders' to 'Wolds'
In Column 'P' in 'Wolds' I have a code to number each order (W1, W2, W3...ETC.) I need this row to remain.
In previous attempts at doing this macro every time it ran it would re add all the orders so some were being duplicated several times on the 'wolds' sheet. I am looking for new orders to be added to the previous one when the macro is run
Thank you.
<tbody>
</tbody>
I am after a formula/macro that will copy a row of data if two certain cells match.
In sheet 25 (Called 'All Orders') I have headings in the columns A-O. The headings are in row 2 and the data starts in row 3.
Sheet 26 (Called 'Wolds') is set out in the exact same lay out.
What I need to do is; If Column E in 'All Orders' matches the text in cell A1 in 'Wolds' then copy the row of information from 'All Orders' to 'Wolds'
In Column 'P' in 'Wolds' I have a code to number each order (W1, W2, W3...ETC.) I need this row to remain.
In previous attempts at doing this macro every time it ran it would re add all the orders so some were being duplicated several times on the 'wolds' sheet. I am looking for new orders to be added to the previous one when the macro is run
Thank you.
<tbody>
</tbody>