excel

Excel macros are my new favorite thing, I lie they have been really useful for years and it is only lately I have started to blog the ones I use every day. Today’s task is getting a list of keywords ready to parse to code, by adding a comma to the end of a long spread sheet of values :)

Continue reading

Excel is an excellent tool, pardon the half pun :) Automation is one of my favorite things about excel. Have you ever found yourself getting copy past blindness, adding hundreds if not thousands of fields to an excel sheet. Using this handy Macro you can save yourself some time and get back to the real work.

Continue reading

So here is the scenario, you have an Excel doc full of plain text links and you need to convert them to clickable links. Normally I would have to click on each cell and hit Enter, this can be very time consuming. Using a small macro you can automate this task. Check out how to save yourself time when using Excel.

Continue reading