Wait till data refresh?

[GSBR88]

Mr excel team and all users thank you for the support and abundant knowledge transfer.


Any better ideas ?

This is Workbook A (name keeps changing)

• I got a number 404 in P1. (total 404,504,604... 40 numbers)
• Once i change the number data is updated in all sheets.
• Then user click Ctlr+Q to run Savme.

Sub SavMe()

Application.EnableCancelKey = xlDisabled
Dim newFile As String, fName As String
fName = Range("p1").Value
newFile = "Cashup" & fName
ChDrive "C:\test\"
ChDir _
"C:\test\"
ActiveWorkbook.SaveAs Filename:=newFile

End Sub

This work perfect,
But is there any way I can automate entry of 40 numbers by macro with a break after each entry till data refresh?

Thank you guys.