Forum Discussion

Chris525's avatar
Chris525
Copper Contributor
Jun 03, 2024

Automate the condition and fill the table

Hi,

 

I need to update a weekly and daily report based on given data. Can you kindly support?

Condition is, when the percentage first reach greater than 70% I need to put the Item code in my weekly table based on the date. How can I do this automatically instead of entering manually.

 

I have attached my file for your kind reference.

https://www.dropbox.com/scl/fi/yncvyaw6rghsn7s1w4pgm/Automate-the-fomulas.xlsx?rlkey=txk09lv041bgtdksiksog1lx9&st=vgm0tyt0&dl=0

 

Thanks

 

excel
Formulas and Functions

3 Replies

  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Jun 07, 2024

    Hi Chris525 

     

    With Power Query:

    • Formatted your data as Table (you can hide row #4)
    • Dates (Tuesdays) in WeeklyTuesday table (output of the query) are dynamically generated according to dates found in Table1

    To update: Right-click somewhere in WeeklyTuesday > Refresh

      • Lorenzo's avatar
        Lorenzo
        Silver Contributor
        Jun 12, 2024

        You're welcome Chris525 

        Feel free to click Mark as answer link (at the bottom of the post) to help people who Search 🙂 - Thanks

Resources