+ Reply to Thread
Results 1 to 1 of 1

Automate Data Values into Text Boxes in real time

  1. #1
    Registered User
    Join Date
    02-11-2019
    Location
    toronto, canada
    MS-Off Ver
    2013
    Posts
    64

    Automate Data Values into Text Boxes in real time

    Hi,

    I created a graph for my company.

    I make this for my personal company once a month.

    The problem is ITS SO MANUAL.

    1. To get to the point E34:F41 will become the new values in text box in the rows 44:48 (right now it's overlaying the graph - DIRECT AND SUPPORT RATIOS)

    2. Additionally, each quarter (Q4,Q1, Q2, Q3, Q4, Q1) has respective "Direct and Support" numbers which essentially in the increase or decrease for a specific team which is calculated in cells D3:O13.

    2(cont). These values I take and very, very manually fill the blue text (i.e +25 will be +9 represnting 359 vs 368 and all the "+" under is will change for their new valies, i.e RE +4 will become RE+5) - note all teams are wont be observable in the blue text as new team were just added!

    Essentially the graph has text for ALL changes to team #'s and the Direct vs Support texts is then dragged between their respective quarters.

    Is there anyway to have automated text boxes that update automatically, even if quarter by quarter since I can always drag it to their places but right now i type EACH ONE and they change ALOT! I'm open to any idea's, if i have to drage 30 of them it's easier than this manual process since numbers can change over and over again!

    THANK YOU **FEELING HOPEFUL**
    Attached Files Attached Files
    Last edited by JPRICH16; 01-25-2020 at 06:08 PM. Reason: wrong cell number

+ 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. [SOLVED] Hide/Unhide text box based on cell value with real-time data from arduino
    By art_a_game in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 12-12-2016, 05:29 AM
  2. Replies: 4
    Last Post: 05-19-2016, 05:04 PM
  3. Text box to pass real -time value from worksheet
    By aditi7 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-18-2013, 01:57 AM
  4. Pop-up text boxes based on cell values then disappeared after preset time
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-11-2013, 07:19 AM
  5. [SOLVED] tracking real-time values
    By okcsteve in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-11-2013, 06:46 AM
  6. Is it possible to automate text boxes!??
    By vakej in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-25-2008, 05:44 PM
  7. Export to text in Real-Time
    By efoda in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-24-2005, 11:48 AM

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