Looking for a BOT i can use for excel
Join Date: Jun 2014
Posts: 63
hi,
I'm looking to create a bot that I can use for excel the main purpose of it is to save me time. I would need it to be able to filter a column that I would call code then click on each number on the column and transfer the cost to another excel sheet which is inline with the code.
Not sure if this is possible but if you think it is let me know
Join Date: Feb 2005
Posts: 13,146
It's surely possible, look in to Excel VBA.
Join Date: Sep 2006
Posts: 12,644
Seems to me this sort of logic is much more suited for a general python/ruby/etc script. The gist of what you want want to do is :
1) Load your spreadsheet (some sort of csv), into memory
2) Perform some filtering logic
3) Update column(s)
4) Write to new csv
You now have your new csv ready to load into Excel. I do not know VBA but I imagine this is far simpler to do than what Dave suggests.
Believe it or not, all of the ^^ could likely be done in < a dozen LOC (or more depending on the complexity of your sorting criteria/update logic)
See my Commercial Software thread
Join Date: May 2012
Posts: 5,395
You could do this with some VBA knowledge.