So the 2 attached spreadsheet are in a different place. Let's say one is under C:\Temp\Reporting and the other under C:\Temp\Tickets
What I'd like it to do is have a macro in [url removed, login to view] that to once the button is pressed copies the relevant rows from [url removed, login to view] to [url removed, login to view] where the Client is the same (Value Paste only). The Macro should be smart enough that it gets the Clientname from workbook TicketlisteSummary in Field I2 for the the search.
I did an example in the spreadsheet for AK 33 so you can understand.
Please only bid if you are familiar with macros and understand what I try to achieve. I would need the macro ASAP. Good luck!