VBA - 3 tasks in a specific order

[RickG75]

Hi All,

I have 3 macros written and working separately.

I would like to combine them and have them complete individually in a specific order:
First: Save_PDF
Second: Sales Summary
Third: Refresh Invoice

Can someone help assign this combined macro to the button called "Invoice Complete" on the Invoice tab of my worksheet?

Here is a link to the file:

Dropbox - File Deleted - Simplify your life

www.dropbox.com

Thanks,
Rick

 

[kweaver]

When you run your "Invoice Complete" macro, have it link/call this one:

Sub RunAll()
Save_PDF
Sales_Summary
Refresh_Invoice
End Sub

 

[RickG75]

Hi kweaver,

Thank for your patience and your help.

All of the macros work accept the Sales Summary is not moving to the next row to record the new data. It is recording over the second row over and over again. Can you have a look and see what I need to change?

Thanks,

Rick

 

[Norie]

Rick

In 'Sales_Summary' you are using column A to determine which row the data should go to, column A is empty so that row will always be row 2.

Change the code to use another column, e.g. B, to determine which row the data should go to.

 

[RickG75]

Hi Norie,

Thanks for the input!

I was way overthinking it.

Many Thanks,
Rick