Hi all,
I have followed this site for some time, and it seems you guys know an impressive vast amount about excel!!
I have made an excel sheet that has to keep track of a range of cameras according to dates. So on the very left column the list of cameras are present, and in the top row the days and dates appear. I have already made it so, that the dates automatically change every day, so the second column to the left always show todays date. The general idea is then, that the sheet at all times will automatically update it self, and no manual changes will have to be done.
BUT I simply do not know how to make the text entries in each column under each date 'move' to the next column on the left every day according to the date.
Does somebody in here know how to do this, and thus help me immensely
Bookmarks