Results 1 to 3 of 3

Thread: Macro to change month and year on all sheet

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 08-14-2013, 05:26 PM #1
    Howardc
    Howardc is offline
    Senior Member
    Join Date
    Apr 2012
    Posts
    193
    Rep Power
    13

    Macro to change month and year on all sheet

    I have a formulas that links to a particular sheet see eg =IF('Jul-2013'!G100>0,('Jul-2013'!G100),"")

    I would like a macro that will enable me to replace the month and year and all sheets with the name ending in JNL

    I have attached a sample workbook. For the sample I only have one sheet with the name ending in JNL, but in practice I will have several sheets with the name ending in JNL

    Your assistance in this regard is most appreciated
    Attached Files Attached Files
    Last edited by Howardc; 08-15-2013 at 09:21 AM. Reason: Attaching sample workbook
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Copy Row To Another Sheet On Change Of Value/Update Value To Another Sheet On Change
    By william516 in forum Excel Help
    Replies: 30
    Last Post: 07-19-2013, 07:52 AM
  2. Automatically Copy Range To Another Sheet Up On Change In Value In Adjacent Column
    By william516 in forum Excel Help
    Replies: 10
    Last Post: 06-20-2013, 12:21 AM
  3. Filter, Split And Move Data For Each Month From Master Workbook To Individual Sheet
    By vivek09 in forum Excel Help
    Replies: 6
    Last Post: 05-20-2013, 10:06 PM
  4. Change Display Range Based On Change of Dropdown Values
    By rich_cirillo in forum Excel Help
    Replies: 2
    Last Post: 03-29-2013, 04:58 AM
  5. Excel VBA Macro To Dynamically Change Source for Pivot Table
    By Howardc in forum Excel Help
    Replies: 3
    Last Post: 03-05-2013, 03:57 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
  •  

Forum Rules