• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. D

    Auto execute vba code when power point opeb

    Hi, I am trying to receive email notifications when someone opens power point deck. I can do it in excel without having any issue however in power point I cant auto execute the code when .ppt file opens. I can manually run it and it works but need it to auto execute. I am using below code, did...
  2. D

    Copy and paste range to every sheet Vba

    It worked! Thanks
  3. D

    Copy and paste range to every sheet Vba

    Hi, I have below code where i would like to copy range from sheet "HE" (G21:AO23) to every worksheet to same range except sheets "Summary" and "HE" I am using below code however it is not copy pasting rather deleting the range. Can anyone help me with what's causing this issue?
  4. D

    VBA Vlookup Help

    Please disregard, modified the code and its working now. Sub Vlookup() OptimizeVBA True Dim startTime As Single, endTime As Single startTime = Timer Dim sWb As Workbook Dim fWs As Worksheet, sWs As Worksheet Dim slRow As Long, flRow As Long Dim pSKU As Range, luVal...
  5. D

    VBA Vlookup Help

    Hi, I modified the code however vlookup returning Blank value. Essentially i'd like it to lookup value in "Summary" sheet column D:D, vlookup Lookup Table column A:B and return the corresponding value in Column B to Summary sheet column C:C. I couldnt figure out why its returning blank value...
  6. D

    Copy Paste Function not Working

    Hi, I have below formula where i like to cut cells from Workskeets("WBC").Range("W22") to Workskeets("WBC").Range("B4:B33") and AB22 to B34:B64. For some reason it doesnt copy and paste to the range on Summary sheet. What may cause this issue? Sub MoveRangeWBC()...
  7. D

    Cut single cell and paste to another worksheet range

    Modified the code as below and it worked Moderator Note: Seems You skipped Your Cross-Posting duties. >>> use code - tags <<< Sub MoveRangeSta() Dim iCntr Dim rng As Range Set rng = Worksheets("Summary").Range("C4:F1111") For iCntr = rng.Row + rng.Rows.Count - 1 To rng.Row Step -1...
  8. D

    Cut single cell and paste to another worksheet range

    Hi, I am trying to rearrange columns and rows in a worksheet. I am using below code to automate the process. It worked seamlessly when I ran the code on same worksheet. However when I cut and paste to another worksheet It doesn't run properly. It cut c ell E3 and F3 from Sta Sheet however it...
  9. D

    Rearrange Rows and Columns with VBA

    Please see attached. Worksheet Sta is how the data is today, essentially i'd like it to look the format like in Future State tab. Please not there are blank rows that i'd like to delete and transpose header to column D (2021 and 2022). Please let me know if this sample data helps. Thanks
  10. D

    Rearrange Rows and Columns with VBA

    Hi, I'd like to rearrange rows and columns of data with vba in attached format. I have worksheet name "Sta". Can anyone help me with with vba code? Thanks in advance!
  11. D

    Power BI add calculated row into a matrix table

    Hi, I have below matrix table that i'd like to add a calculated row (highlighted in red) on the bottom of the table. I have calculated measures for 2020 and 2021 (Returns/Gross Sales) but not sure how to add to the table. Can any help with the formula? P&L 2022 2021 Chg Gross Sales...
  12. D

    Calculate % off another row value with a dax formula

    I have a table name sales and trying to calculate % off gross for each value. I tried numerous dax formulas but couldnt get it to work in Power BI. Does any one know how to calculate % of Gross for each row in below table in Power BI with dax formula? Sample Calendar Year Customer PL Line...
  13. D

    How to subtract prior year sales from same column in Power BI

    Hi, I have a financial data set for CY 2020 and 2019. I am trying to subtract year over year data from corresponding P&L. My Value and Calendar Year data is in same column. Please see attached sample file. Is this something that can be done in power BI dax formulas. I appreciate if any one...
  14. D

    Price Optimization Based on Elasticity

    Hi, I have below retail, cost, elasticity, and unit sales data. We are looking to lower the retails. Is there an excel formula that gives the best lower optimum retail that maximizes revenue? Retail $5 Cost $1.5 Elasticity 1.23 Units Sold 178,321
  15. D

    How to calculate price elasticity

    Thank you for sharing the formula and methodology. Is there a way to confirm the significance of the model whether if it is predictive? Also how would the formula change if there is more than one variable on the X axis. For Ex: In addition to price, if we add seasonality, and merchandising ...
  16. D

    How to calculate price elasticity

    Hi, I have 52-week sales trend data at various price points. How can I calculate the price elasticity of demand based on the trend data? Attached is the sample data set. Does anyone has experience with PED calculation and have a solution for it. Thanks
  17. D

    Countly Only Unique rows with matching criteria in another column

    Hi, I have a range where I am trying to count only unique values with matching criteria in cell C.. In below examples I am trying to get the unique count in column A where C is "Inactive - Use Up Inventory" The result should only be 1 as GSF11-BLK is only unique value in column A where Column C...
  18. D

    Price Optimization Problem

    Hi, I need help with price optimization based on price elasticity of demand. I know the units sold at various price points and elasticity of demand of the product. What would be the formula to find out what the optimum price point? Thanks
  19. D

    Refresh all Pivot Tables

    I have below code where i need it to update all the pivot tables if the values between A:C changes. However it is not working. Can anyone help? Thanks
  20. D

    VBA code to select range with non blank values

    Hi, I have below code i use to determine to range with last used cell. However it returns the last used cell with formula that returns blank. Is there a way to modify the code where it returns the range with values so that range doesn't includes formula returning blank value.
  21. D

    Changing formatting based on Option Button Selection

    Hi, I have table that is controlled by 3 option buttons. Each button determines whether the values will be dollars, or numbers. I am using below conditional formatting but i'd like to make it dynamic based on option button selection. [>=1000000] $#,##0.0,,"M";[<1000000] $#,##0,"K";General Is...
  22. D

    VBA Left Offset Code

    Hi, I have a below code i am trying to modify. I have a value in cell P11. if the value in cell P11 starts with "L", I'd like to put "L13W and the last 8 digits of cell P11 in Q11. Can you please help Sub RightFunction() Dim c As Range For Each c In ThisWorkbook.Sheets("Data").Range("P11")...
  23. D

    Trendline go below 0

    Thanks
  24. D

    VBA to calculate share by brand by Retailer

    Hi, I have a spreadsheet where i am trying to calculate share for each brand in different categories for various retailers via using VBA. Please see attached sample file. for Walmart Share calculation should be R3= Persil =L3/L2 R4= All =L4/L2 R5= Purex =L5/L2 R6= Sun =L6/L2...
  25. D

    Trendline go below 0

    I don't know how it happened but issue fixed itself.
Back
Top