Hi
I am trying to find a macro that will copy and paste a variable range depending on content of start & finish Cells.
My Data is in sheet1 Columns A:E and goes down over 200 rows, and it contains a list of invoices for different suppliers that require paying,
I want the macro to Find the Suppliers Name (Col A), which is in G1 and then copy and paste to Sheet 2 until it reaches the Total of that supplier which is referenced in G2
Hope someone can help