Results 1 to 19 of 19

How to create a dynamic report?

Threaded View

  1. 08-07-2023, 02:14 AM #1
    Manith
    Manith is offline
    Registered User
    Join Date
    02-20-2021
    Location
    US
    MS-Off Ver
    2019
    Posts
    54

    How to create a dynamic report?

    Hi All,

    I have an excel report which need to be dynamic without using the pivotable. The pink color need to be filled base on the sale details data.
    Please note that Credit off, Free Cleaning kits, Free Bag, and Paper bag needs to exclude from sale report.

    And the formula should be working in Excel 2019 as well.
    For ur reference, the problem also posted in another forum as below link:

    https://www.mrexcel.com/board/thread...table.1242655/

    Please find attached for the excel file.
    Thank you!
    Attached Files Attached Files
    Last edited by AliGW; 08-07-2023 at 02:53 AM. Reason: URL fixed.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. To make dynamic bucketwise report from Ageing report while providing days from form
    By Hanky in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-11-2021, 03:00 PM
  2. How to create pivotable data easily from multiple tabs with same format
    By ammartino44 in forum Excel General
    Replies: 1
    Last Post: 04-29-2019, 03:01 AM
  3. Dynamic Scatter Graph from DataTable from Pivotable (2013) PowerQuery not an Option
    By ismailc in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-21-2018, 04:59 PM
  4. [SOLVED] I need to create a pivotable and chart from a dataset but am struggling, please help
    By willm in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-12-2018, 06:25 AM
  5. Trying to create a dynamic report that pulls sales data from another tab based on week
    By uahmed90 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-26-2017, 10:05 PM
  6. Create a List That is Pivotable
    By Cecil in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-16-2012, 03:06 AM
  7. Create a macro to change pivotable
    By harbors in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-15-2012, 03:27 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1