+ Reply to Thread
Results 1 to 2 of 2

Performing Multiple Commands in a single macro (Macro novice here!)

  1. #1
    Registered User
    Join Date
    11-09-2012
    Location
    United States
    MS-Off Ver
    Office 16 / 365
    Posts
    14

    Performing Multiple Commands in a single macro (Macro novice here!)

    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

  2. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Performing Multiple Commands in a single macro (Macro novice here!)

    It's possible, but attach a sample file, not png, with before and after macro run
    If solved remember to mark Thread as solved

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1