+ Reply to Thread
Results 1 to 5 of 5

clear out 3 calendar tabs and update latest content based on information

  1. #1
    Registered User
    Join Date
    04-04-2018
    Location
    Seattle
    MS-Off Ver
    Windows 1708
    Posts
    2

    clear out 3 calendar tabs and update latest content based on information

    HI

    I have a history of coming here every blue moon for help with macros

    Adam
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    04-04-2018
    Location
    Seattle
    MS-Off Ver
    Windows 1708
    Posts
    2

    Re: HELLO, Need MACRO Help.

    HI- My intro is a question. I have an excel sheet where Im trying to get my macro to clear out 3 calendar tabs and update latest content based on information the tracking sheet tab.

    Tracking Tab
    Column A has the country (US and CA)
    Column R has the date
    Column G has the text that needs to be displayed.

    Column A determined the country calendar tab, Column R has the date in which that content needs to be placed on the specific calendar tab. Column G contains the text that needs to be placed.

    Here is a link to the excel sheet is attached above

    Here is the macro code: Any help would be appreciated. Errors at the bottom on the fRow line.

    Please Login or Register  to view this content.
    Last edited by Pepe Le Mokko; 11-30-2019 at 12:49 PM.

  3. #3
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: clear out 3 calendar tabs and update latest content based on information

    Hi and welcome
    in the future please start threads in the proper forum, not the first forum / sub-forum you happen to open ( this one you opened in the " Introduce yourself" forum...)
    I moved it to the correct forum for you

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: clear out 3 calendar tabs and update latest content based on information

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however you need to include code tags around your code.

    Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

    Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    I did it for you this time. Please read forum rules. Thanks

  5. #5
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    880

    Re: clear out 3 calendar tabs and update latest content based on information

    Maybe something like this?
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Clear Rows Content Based on Cell value and key word
    By Excelnewb1567 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-14-2018, 07:05 PM
  2. [SOLVED] Macro to Clear Cell Content based on a condition
    By pchugh in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-23-2018, 08:48 PM
  3. [SOLVED] How to clear content based on value?
    By putritersenyum in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-05-2016, 01:13 PM
  4. Powerpivot - Returning latest update based on latest date
    By Kehjz in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 08-22-2013, 02:45 PM
  5. Replies: 2
    Last Post: 07-10-2012, 02:10 AM
  6. Clear content based on date?
    By Ltat42a in forum Excel General
    Replies: 3
    Last Post: 04-06-2012, 08:19 AM
  7. Replies: 5
    Last Post: 03-30-2010, 08:33 PM

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