Closed Thread
Results 1 to 2 of 2

No direction with time traveling!

  1. #1
    Registered User
    Join Date
    Watonga, Oklahoma
    MS-Off Ver
    Office 2007-2010

    No direction with time traveling!


    Im scratching my noggin on a little bit of data coming from a userform, and how to make it work like I want to.

    My userform is for inputting 143 numerical USD values that are collected every day.
    Values from the userform goes to a sheet we can call the "Sleuth" (43 statically labeled rows, 10 statically labeled colums....not all rows use all 10 columns that's varying per row)
    I need this fresh data that I get every day to reference with yesterdays numbers and highlight decreases in values only.
    I wouldn't mind recommendations for good practice with this sort of reference data like, should I keep it all on one sheet, or should I store it in another sheet and make a macro to clear it out and transfer todays values into "yesterdays" once its all done so its ready for just new numbers tomorrow.
    Since I need to do this 143 times, we can nibbles at this, or if there is quicker ways I can frustrate you while I try figuring that out.

    I'm in no hurry on this, just ready to start doing it differently....I know i'm confusing already so thanks in advance for responses and patience already!


    Wrong part of the forum, sorry about this.
    Last edited by thefritz420; 03-14-2017 at 04:54 PM.

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    Tysons Corner, VA, USA
    MS-Off Ver
    2010, 2013, 2016

    Re: No direction with time traveling!

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.

    Making the world a better place one fret at a time | | |會 |會 |會 |會 | |:| | |會 |會

    If someone helped you, please click on the star icon at the bottom of their post
    If your problem is solved, please go to Thread Tools and select Mark This Thread Solved
    Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.

Closed Thread

Thread Information

Users Browsing this Thread

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


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