Capture2.PNG
Above is an example of an Excel spreadsheet I have that controls and lists my current progress on a number of shows I watch. I would like to make my life simpler and create macros/buttons that would do the following actions:
If I were to select a row, say the row with Modern Family, and update that row so that I am an episode behind on viewing it, I would do the following:
Column A: turn the font color to red
Column C: add 1 to the cell value
Column K: add 7 to the cell value, turn background color to yellow, and font color to black
Ideally, if I wanted to update a day's worth of shows (say Big Bang Theory and Office since they appear on the same night), I would like to be able to select multiple rows at once, and perform the macro so that it does this action row by row (updating Columns A, C, and K accordingly for each show). Then, after the modifications were done, sort the rows by Column K (a date function) so that they're back in proper order.
Is this possible? If so, could I possibly get a few tutorials from the experts here in these forums?
Thanks guys,
Alex
Bookmarks