Hello all!
After considerable time spent searching online trying to find a solution to my problem I've decided to try posting here in hopes that a solution is possible. I feel like what I need should have a simple solution, but I've run out of energy trying to find someone with a similar scenario and solution. I'm hoping that someone here is kind enough to offer some help. Enough of my ranting, here's the problem:
I have a Workbook I've made whose cells correspond with blanks I need filled in a Web Form. What I'd like is to automate copy/pasting the values in those cells to the 50 or so blanks in the Form. Copy, alt+tab, paste, tab, alt+tab, down, down, copy, alt+tab, paste, tab, alt+tab, right, up, up, repeat until the Form is filled out (with a variation here and there). Seems simple enough to me, but I've yet to find a way to accomplish the task. I tried recording a Macro to do it, but it didn't register the alt+tab as part of the process and failed. Bummer. Is it possible to do with with Excel/VBA? Any help would be /greatly/ appreciated.
Bookmarks