dynamic

I am trying to build a dynamic table that changes based off of what you select in a drop down but it pulls data from different tabs. I can make it work when it is just looking at 1 tab but I would have multiple people populating their own tables on their own tabs so I want the home page to show...

I have a data table say A1:N100 Column A is Category Column B is Sub Category Columns C:N would be Jan - Dec I need a dynamic sum that only sums up if Category A value is "Criteria1", Category B value is "Criteria2" and for only the month of my choosing. Sometimes this will be current month...

Hey all, I have a problem and have NO idea how to solve it - it is about a dynamic sheet that should show a timeline (Calendar weeks) and quantities in that timeline. Attached is an sample workbook with all information -> 20230522_SAMLE_WORKBOOK.xlsx But here are additional information: B12 &...

I have a main summary tab and then multiple additional tabs for other more drilled down summaries. My main summary tab has a drop down list of places. So when I click Place 1, my main summary and all additional tabs will now only show Place 1 results as all additional tabs are just linked back...

Looking for a method to have formulas populate when entering data without dragging, etc. For example, if I copy a column of data from one workbook (e.g. - a data download) into Column "A" of another workbook, I would like to have the columns next to the copied data automatically populate with...

Is there way to create a dynamic named range based on cell values from other columns? The cells in the named range may not be contiguous. For example, I have a list of holidays or other observed days. I want a dynamic named range of the Day column to reference only those marked as Type...

Good day everyone, I've searched several forums but couldn't find an answer to my question. Maybe it's not even possible in Excel but we'll see... So, I've got my table with three columns Region, Shoe Size and Sales. What I want to achieve is to create a Top N list of shoe sizes and their...

Hi all, I found formulas to calculate the fiscal year, but I'm trying to figure out a dynamic formula that will calculate if a date is within the current fiscal year (fiscal year for me starts in August). For example, I would like the result to show the following for these dates...

Hi, I have the following formula which is inserted on sheets through VBA code: =SUMPRODUCT((B3:AF3="AD")*(WEEKDAY(B2:AF2,2)<6)*(ISNA(MATCH(B2:AF2,HolidaySheet!A2:A3,0)))) The A2:A3 range contains two holiday dates which are on a separate worksheet. The holidays change depending on the year...

Hi! I'm looking to create a chart with multiple lines, each one representing a different day's worth of data. As I add more lines, I want the newer data to be shown in a different color as the older one, forming a gradient among the lines that makes it clear which data is more recent. This could...

Hi alll, Just coming up with a difficult problem at the moment. Trying to SUM forecast data in a Range, but using unique variables to decide what that range is. Forecast Sheet is as follows; A2123456 Stock Sheet is as follows; F25 We want to be able to see based on the Date stock goes...

Hi, I have a data table of financial securities, each item(row) corresponding to a certain country/region of issuance. I would like to have that table filtered automatically to show only those securities issued from a specific country and region selected from a dependent drop-down list...

VBA newbie here. I'm starting with a single workbook that has 2 sheets. With this, I'm trying to figure out code that would accomplish the following on execution: Create an Array with n elements, where n is the number of Unique Strings found within the Cells in Column B (excluding B1 and...

Hello, I'm looking for a macro that will dynamically change the comments attached to a range of cells (entering the results from the formula in the cell), triggered by the change in value of another cell. Specifically... I'm looking for a macro that will be triggered by any changes to the...

Hello All, So basically there are several KPI's where the 'Target' Value can vary on a Month by Month basis. I would like to create several Conditional Formatting scenarios that highlights it as Green, Yellow, Red and Blue based on how close the ACTUAL figures are to said Target. At the moment...

Need help to create a macro to extract the following data (highlighted in green) from Multiple Worksheets onto the Summary sheet: Month of Report onto E1 Date of Report onto E2 Carpark ID on column D Carpark ID + Lane ID onto column E Percentages for Hourly, Season Parking and Total on column...

Greetings, I have a dynamic chart in a dashboard that changes based on what year I select. Some of the items have no data for 2021 but has data for 2022. How do I hide the line items by year which currently has no data?

Hi Power Query gurus out there! I'm going to do my best to explain some help that I need it replacing values, conditionally based on another column's values, while dynamically referencing field names. Here's some sample data: Date Greeting Appreciate Patience (if hold was used) Resolution...

Basically, I want autofill to skip reference columns at a static rate. I have the formula "=SUM('FPY Data'!K5:K54)-SUM('FPY Data'!L5:L54)" in column E. When I drag autofill across column F is "=SUM('FPY Data'!L5:L54)-SUM('FPY Data'!M5:M54)" but I want it to be "=SUM('FPY Data'!R5:R54)-SUM('FPY...

ABCDEFGHIJKLMNOPQ1Sheet 1Sheet 2Sheet 32Account No. & Account NameDateCounterpartyTextDebitCreditAccount No.Account NameBalance (Debit)Balance (Credit)DateAccount No. (Debit)Account No. (Credit)AmountText341200...