Within a Workbook, I have a window (Sheet2) that needs to be active for entering raw data and a window (Sheet1) that will be up on a monitor, showing live, manipulated data. In order to keep the current line item on the screen I have it run Application.Goto Target.EntireRow on Sheet1, which selects and scrolls to the most recent entry row on my report sheet in its open window and does what I need it to do. The problem is, I need to get back to where I was in Sheet2 to continue making entries. My only interface is a scanner, so I can't alt-tab (it's ascii based so I can't scan an alt-tab either). I have tried SendKeys to alt-tab back, but it only works about 95% of the time, which won't work (I have tried pausing and DoEvents to assist the SendKeys, but it still consistently fails). Since it's within the same application and the same workbook, none of the options I have found apply. When I try to Activate a worksheet, it changes the worksheet in the active window, instead of going to the open window of that sheet like GoTo does in the first move. My current thought is using Application.GoTo to get back, targeting the first empty cell in the first column of Sheet2. I'm still very new to VBA, so I wouldn't know how to accomplish this. I appreciate any help you can provide in coding this idea or if you have any easier ways to accomplish this, that would be great too!