Hi,
As an initial step ... turn on your macro recorder ...
Then go through your process for one invoice ...
This will create a "VBA translation" of your actions for one record ...
Then, will come the step to optimize your macro ...
Hope this will help