I'm having trouble with the how to call the column and loop to the next column. The goal in the end is to copy cells one at a time and assign a variable to each cell in a row and then loop through that on the following row.
So...
ColumnLoop
B3 Copy to clipboard Paste to Variable appended with A3
C3 Copy to clipboard Paste to Variable appended with A3
through to Column H
RowLoop
Should do the same as above but on Row 4
This award is reserved for members who have accomplished extraordinary things, sustained quality tech contributions, and shown great leadership efforts over a long period of time.
Let me know if you're able to leverage that code into what you're looking for this time. If not, I'll take a run at it for you, in which case it would be helpful to have a sample input spreadsheet and the output spreadsheet that you want from it (I don't understand your exact requirements from your post). Btw, as a side comment, I'm sure that the clipboard won't be involved...we'll use variables in the AutoHotkey script, not the clipboard. Regards, Joe
This award is reserved for members who have accomplished extraordinary things, sustained quality tech contributions, and shown great leadership efforts over a long period of time.
> that is pretty much exactly what I am trying to do again its just been a while since I could work on it
OK, then let me know if you can get it to work for you this time or if you need help revising the AutoHotkey code.
> the clipboard can get messy
Exactly! Your original post at the previous thread used the clipboard, but my revised, "much better" way did not...everything needed is stored in variables in the script. Regards, Joe
This award is reserved for members who have accomplished extraordinary things, sustained quality tech contributions, and shown great leadership efforts over a long period of time.
Hi Stuart,
I'm trying to clean up open questions at EE...this is one of them. Do you need more help with it? Regards, Joe
Not the solution you were looking for?
IT issues often require a personalized solution. With Ask the Experts™, submit your questions to our certified professionals and receive unlimited, customized solutions that work for you.
Premium Content
You need an Expert Office subscription to comment.Start Free Trial