Hello,
You can easily do that using our advanced macro product, Workspace Macro Pro 6.5.
You can download the trial version from
http://www.tethyssolutions.com/macro-automation.htm
When you record the macro, simply open it in Editor by clicking on Edit button and insert a 'Pause' command from the left hand side list of commands at appropriate place.
When the macro runs, it will pause when it finds the pause command and it will wait until you click on the Resume button. You can enter the information and hit the Resume button and the macro will continue.
Hope that helps.