+ Reply to Thread
Results 1 to 7 of 7

Pulling Data at the End of A Business Day

  1. #1
    Registered User
    Join Date
    03-26-2021
    Location
    TEXAS, USA
    MS-Off Ver
    MICROSOFT 2016
    Posts
    4

    Pulling Data at the End of A Business Day

    Hi! I’m sure you get so many messages but hopefully you can answer mine!! I was wanting to see if there was a formula I could use to pull data value (numbers) from a cell to a new cell based on time and date. For example, at the end of Friday at 5 PM I want to see how many people are on X column (I have a total at the bottom of the cell). Then the following week, as I make changes, i can see the variances. hopefully you can assist! I currently have two columns. What I was doing is copying and pasting values at the end of the week and allowing my totals to auto-update (sum function). And then I would create a variance line.

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX & Windows
    Posts
    7,321

    Re: Pulling Data at the End of A Business Day

    would help if you posted a sample sheet with expected results - see the yellow banner at the top of the thread
    Wayne

    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    03-26-2021
    Location
    TEXAS, USA
    MS-Off Ver
    MICROSOFT 2016
    Posts
    4

    Re: Pulling Data at the End of A Business Day

    Thank you for your speed response. Please see attached.
    Attached Files Attached Files

  4. #4
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX & Windows
    Posts
    7,321

    Re: Pulling Data at the End of A Business Day

    not sure what you need here , no X column ?
    also explanation of whats need with a reference to the spreadsheet

  5. #5
    Registered User
    Join Date
    03-26-2021
    Location
    TEXAS, USA
    MS-Off Ver
    MICROSOFT 2016
    Posts
    4

    Re: Pulling Data at the End of A Business Day

    Hello!

    Premise: I have to compile a chart that denotes values from last week to this week. Every Saturday, the sheet should pull the transfer the this week column to last week column and pull info for the new week. It all needs to be done in a single chart (not two) as I want to have a line graph auto-updating every week. Info is pulled from the first table under Maria.

    After a bit more brain storming, I think I need a macro, rather than a formula... I am not entirely sure.
    Attached Files Attached Files

  6. #6
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX & Windows
    Posts
    7,321

    Re: Pulling Data at the End of A Business Day

    yes , you would need a macro, VBA I dont answer here , as a function will look at the sheet and update each time new data is presented

    It maybe worth closing this thread, MARK AS SOLVED , and post a new question BUT IN THE VBA FORUM, with the full details , and the example spreadsheet , BUT show some expected results , also will the sheet be opened on a saturday and the macro run, ???? or are you expected some sort of scheduler to run with the PC ON ?

  7. #7
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    23,878

    Re: Pulling Data at the End of A Business Day

    Not clear whether for "Last Week/This Week"" has to be static for your plot and hence the need for VBA

    =INDEX(MARIA!$B$3:$W$25,ROWS($1:1),MATCH('RECURRING TABLE'!$B$3,MARIA!$B$1:$W$1,0))

    This pulls data for date in B3 and similar for B4

    As dates in B3/B4 change, data will be updated.

+ 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. Replies: 3
    Last Post: 01-08-2021, 02:55 PM
  2. Replies: 3
    Last Post: 12-14-2020, 09:43 AM
  3. Adding business days to a business day formula
    By snappytim in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-29-2013, 07:36 PM
  4. Pulling a Specific Cell when Pulling a Tabel from Web Based Data
    By Zallen89 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-26-2013, 05:39 PM
  5. Replies: 1
    Last Post: 09-14-2012, 02:18 PM
  6. Last business day of month function +1,2,3,4 business days
    By dstock in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-21-2008, 06:08 PM
  7. WHERE CAN I GET A BUSINESS PROPOSAL OR A BUSINESS EXPENSE SHEET?
    By FELICITA ROSALES in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 08-18-2005, 05:27 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