I am trying to make a simple form to track my body weight and measurements, but knowing next to nothing about Excel I am having trouble figuring out how to get it to do what I want.
Column A contains the labels of what measurements are going to be taken (i.e. Neck, Right Bicep, Left Bicep, ect...). Column B will be where the coressponding data will go. I want there to be a button that shifts all the columns, starting with B to the right so that B would now be free to enter the most current values. I am trying to set it up so that B1 shows the current date, but when I click the button that moves everything over, I want whatever the value is in B1 at the time to moved over so that I can look at the columns and see when the data was recorded. I would enter the date manually, but at some point, I would like to be able to bring up a chart that shows progression and those dates.
any ideas?
Bookmarks