Results 1 to 3 of 3

Thread: change cell content if sheetname is greater than a date on another sheet
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Aug 2018
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default change cell content if sheetname is greater than a date on another sheet

    I have multiple daily sheets that are named by date starting at 01012019. I have another sheet that is named MovingLeaving. I am looking for a way to update one cell value on the daily sheets starting from a date on the MovingLeaving sheet and I need that value to update on every newsheet added that the name is greater than the date on the MovinLeaving sheet. I have a sample workbook but am not sure how to attach it.
    Thanks in advance for the help!

  2. #2
    New Member
    Join Date
    Aug 2018
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: change cell content if sheetname is greater than a date on another sheet

    Anyone have any ideas on how I can accomplish this?

  3. #3
    Board Regular My Aswer Is This's Avatar
    Join Date
    Jul 2014
    Posts
    15,382
    Post Thanks / Like
    Mentioned
    27 Post(s)
    Tagged
    10 Thread(s)

    Default Re: change cell content if sheetname is greater than a date on another sheet

    Sorry to see you have not received a answer since March 29

    But here are my questions:

    1. Is This:
    01012019

    Month Day Year

    Or Day Month Year

    2. You said:

    I am looking for a way to update
    one cell value
    on the daily sheets
    starting from a date on the MovingLeaving sheet
    and I need that value to update on every newsheet added that the name is greater than the date on the MovinLeaving sheet


    You keep saying a cell but do not say what cell. Each sheet has millions and millions of cells
    So how do we know what cell?

    And how will we know when a new sheet is added?

    We always need specific details like Range("B16")

    Maybe with a few specific details we can help you.

    Be sure and always test this script on sample data the first time you use this as to avoid any problems with your data. Always trying to learn more and help others where I can. I'm using Excel 2013.
    Patience please Iím not perfect yet. "Memories are forever"

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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