+ Reply to Thread
Results 1 to 2 of 2

Need last 7 days my Debit Payment at once from multiple sheet in one workbook.

  1. #1
    Registered User
    Join Date
    02-23-2021
    Location
    Minawali, Punjab
    MS-Off Ver
    2016
    Posts
    2

    Need last 7 days my Debit Payment at once from multiple sheet in one workbook.

    Need last 7 days my Debit Payment at once from multiple sheet in one workbook.

    Hello Everyone! i am new here and i like this forum is greate place to share knowledge about excel.

    i am transporter and i have multiple sheet in excel workbbook.

    i need help that i have payment details on sheet like Credit and debit.
    i want to see all my last debit and credit entry at once.

    how this possible on excel??

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,423

    Re: Need last 7 days my Debit Payment at once from multiple sheet in one workbook.

    Hello sohaibahmadu and Welcome to Excel Forum.
    As you are using the 2016 version of Excel it may be possible to consolidate the data on the sheets using Power Pivot or Get & Transform (Power Query).
    After consolidating the data you might be able to display the last 7 days of data using a pivot table or formulas.
    That said, it is easier to say whether or not it is possible if we could see a sample workbook (instructions are given in the banner at the top of the page).
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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] Creating monthly workbook with days as its sheet tab
    By buvanamali in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 01-09-2020, 08:15 AM
  2. [SOLVED] How to get sum of overdue payment based of given credit days period
    By devawad in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-18-2018, 02:16 AM
  3. Counting days since last payment
    By Xsiv in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-04-2014, 11:04 AM
  4. debit value plus a single / multiple credit value is zero that needs to be marked
    By kartikeypatel in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-02-2013, 05:10 AM
  5. [SOLVED] Using days of the week to calculate payment to part-time workers
    By pschatz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-07-2011, 12:53 AM
  6. payment days Table
    By amygdalus in forum Excel General
    Replies: 3
    Last Post: 11-19-2009, 04:17 AM
  7. set payment date 28 days after following friday
    By rhydim in forum Excel General
    Replies: 3
    Last Post: 08-22-2006, 07:30 AM

Tags for this Thread

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