I have two 'macros' that work with each other to pull information I need daily. One is in excel that will go to the first availble cell in the worksheet and paste the information. The other is in Word that will copy the information. Both will perform a certain task, then a message box will appear that is basically a 'pause' until I work on the next step in the other macro. Here's how it runs:
Finds first empty cell in column 'b' of sheet one, then message box comes up.
Run the macro to find the information needed then copies to clipboard, then message box pauses.
Pastes infromation from the clipboard, goes to sheet 2 to the first empty cell of column "B" and message box pauses
This is a lot of back-and-forth that I have to do (when my system doesn't lock up on me...). Is there any way that either I can combine all this into one VBA macro so I can just run it and be done with it...or is there any way to copy all the information I need from Word into the clipboard? In the past, I have been able to copy several items to the clipboard and a box would come up with showing I had these items in the clipboard, but I have no idea how it happend.
Any and all suggestions will be greatly appreciated!