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
attach please a sample file with data and desired result
If solved remember to mark Thread as solved
Thanks for your reply, I hope the attached file helps,
The start and finish is produced from a drop down list, and the result on sheet 2 is entered into an email,
Test.xlsx
Hi, massivemike,
maybe this can give you a hint:
Ciao,
Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
That work great, Thank you so much, I have been trying different VBA for weeks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks