Results 1 to 5 of 5

Thread: Table array pull between dates

  1. #1

    Table array pull between dates



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,

    I have been working on this spreadsheet (trimmed for upload) with an excel guru at the non profit I work at, but he has recently left the company and I am left to finish it, The spread sheet was supposed to be complete until our team started using it, Basically if you look at the tab "Cory Strong" the TO and FROM tables pull information from the PRONTO tab, and their personal counts comes from the PERSONAL COUNTS tab, what I need it to do is for the TO and FROM tables to pull the information based on the personal counts dates in cell C19 and C20. those are the dates that the information must come from in order to perform weekly reconciliations

    Thank you for any help with this
    Attached Files Attached Files

  2. #2
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    357
    Articles
    0
    What I need it to do is for the TO and FROM tables to pull the information based on the personal counts dates in cell C19 and C20.

    So you want to replace the 'Most Recent, 2nd Most Recent ..." layout in the To/From areas with just two rows, based on the dates in C19 and C20?

    Your problem is a little unclear to me. Can you elaborate further, or even put some callout shapes in the file to explain more simple 'I need this to do that based on...'

  3. #3
    I want the 5 most recent entries to show up but only if they fall between the dates in C19 & C20. I just have 5 there depending if they do more transfers or not. We reconcile our stock weekly, and this will show all the transfers from pronto, but only between their most recent personal counts.

  4. #4
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    357
    Articles
    0
    Sorry, this slipped off my radar. Do you still need assistance with it?

    So I take it there is one similar tab for every rep? How many reps are we talking about in total?

  5. #5
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    357
    Articles
    0
    Try this file, and see if it does what you need. Note that i've made some changes to better leverage off Excel Tables, meaning the formulas will continue to reference the source data as the source data expands. Copy of Pronto Master 5 - Test 1 v2.xlsx

    Also note that I inserted a 'helper' column into column B and then hid it. And I also changed the names in row 18 to exactly match the column headers in the Personal Counts tab, as this allowed me to much simplify and streamline a whole bunch of formulas.

    Let me know how you get on.

    Cheers.

    Jeff

Posting Permissions

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