Inserting cells (shift cells right) using macro

May 5, 2016
Reaction score
Hi Everyone,
I'm trying to put a spreadsheet together that will work like a bar graph. This will show how often a list of people have seen a certain specialist, so column A will have a list of names and next to those names in column B there will be a '+1' button. When the user clicks the button an extra cell will be inserted to column C and formatted in a given colour, shifting those next to it right. The idea is that by clicking the '+1' buttons next to the name, you'll effectively be building a horizontal bar graph for easy visual representation of who has been seen how many times.

My knowledge of VB and writing macros is still in its infancy, but I like to tinker, so please be gentle.

Many thanks.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question