Hello, I'm not 100% sure if this is the right place for the question, so feel free to move it.
I work on excel everyday working on a database for a website which sells car parts. I have to organize data into a certain format in excel. There are some things that i do that are the exact same thing, over and over. I was wondering if I would be able to run a macro/bot of some sort that can do this for me, faster.
For example, i want a bot to press:
cntrl+c (copy)
alt+tab (change windows)
ctrl+f (find)
cntrl+v (paste)
enter (find the text)
click (on the close button on find window)
cnrl+c (copy found text)
alt tab (change windows)
cntrl+v (paste over text)
alt tab (change windows)
click (on the change color button in excel)
alt tab (change back)
arrow down (go to next entry)
then repeat again, over and over.
If anyone could help me it would be greatly appreciated. Im pretty sure this is possible, but i have no experience in programming and such.
If you can't help, any other forum recommendations where i can ask this question would be helpful
Thanks.
-Matt
I work on excel everyday working on a database for a website which sells car parts. I have to organize data into a certain format in excel. There are some things that i do that are the exact same thing, over and over. I was wondering if I would be able to run a macro/bot of some sort that can do this for me, faster.
For example, i want a bot to press:
cntrl+c (copy)
alt+tab (change windows)
ctrl+f (find)
cntrl+v (paste)
enter (find the text)
click (on the close button on find window)
cnrl+c (copy found text)
alt tab (change windows)
cntrl+v (paste over text)
alt tab (change windows)
click (on the change color button in excel)
alt tab (change back)
arrow down (go to next entry)
then repeat again, over and over.
If anyone could help me it would be greatly appreciated. Im pretty sure this is possible, but i have no experience in programming and such.
If you can't help, any other forum recommendations where i can ask this question would be helpful
Thanks.
-Matt