Search results for query: *

Hi I need some help with an Excel formula. I have used the sumproduct formula to add up the respective company code amount. Each company code has a percentage split and I'm not sure if the sumproduct formula can accomodate it. Test File uploaded with expected results. Thanks...

Hi I have multiple worksheets whereby cells are referencing to pivot tables. Getpivotdata function was turned off when cells were refenced to the pivot tables. Hence, cell formula is showing cell reference instead of getpivotdata function. Is there anyway to bulk change / update from cell...

Hi I'm trying to populate from column D to S with value from column B. Criteria: 1. If Period (column A3:A14) = Period (column D1:S1), then insert value (number of times as per column C across columns) Attached is the raw data with results i am trying to achieve. Thanks...

Hi I have a workbook with 10+ connections. Some connections are not being used. These connections are used to produced an OLAP-type PVT. Each connection having their own connection name. Naming convention can be random. I'm looking for a vba code to loop through all connections in the workbook...

Hi Needing some help with Pivot Table calculated fields or suggested solution. Attached is a worksheet with data and pivot table. I have entered the expected outcome required below the pivot table. As i am not sure how to get the pivot to calculate what i want, I have hence put in formulas...

Hi Seeking help to pass a variable in the below code. Period = ActiveSheet.Range("A1") ' Range("A1") = Jan 2001 Working WS.PivotTables(Pvt.Name).PivotFields("[Date].[Year].[Mth]") _ .VisibleItemsList = Array("[Date].[Year].[Mth].&[Jan 2021]") Not Working...

Hi Is there a way to sum multiple items from a powerpivot when it is referencing to 2 cells? A1 = Pivot data field B1 = Pivot data C1 = Field 1 D1 = Item 1 E1 = Field 2 F1 = Item 2 G1 = Item 1a H1 = Item 1b Formula = getpivotdata(A1&"",M1,C1,D1,E1,F1) - If referencing to only Item 1, it...

Hi When i drill through a pivot table, is there a way of opening the drill through in a new workbook instead of a new worksheet? Thanks, arv

Hi Hoping someone can assist. When a user opens the workbook, user's access is controlled by: 1. Worksheets as stated on the Access worksheet (Column B) 2. Username = UNameWindows Access worksheet will be maintained to either remove or end-date a user. New users will be added and granted...

Hi Hoping someone can assist. When a user opens the workbook, user's access is controlled by: 1. Worksheets as stated on the Access worksheet (Column B) 2. Username = UNameWindows Access worksheet will be maintained to either remove or end-date a user. New users will be added and granted...

Hi Is there anyway to restrict the filter to selection made? Example: If Company 10 selected on the selection worksheet, then only those Departments associated with Company 10 is listed for selection. If Company 10 selected on the selection worksheet, then only those Sub Departments associated...

Hi Hoping someone can help. What I'm trying to achieve is: 1. I have a workbook with multiple worksheets. There are 5 or more users. What i am trying to achieve is to restrict each user to look at certain worksheets. It can either be 1 or multiple worksheets. 2. Within the same workbook...

Hi Trying to build a model but having formulas across many rows and columns seemed to render the file size really huge. Sheet 1 - Each column represents the day and extends to 2 years. Sheet 2 - Input data for expenses (various category of expenses that I will determine/make an assumption which...

thread68-1802367 Hi Skip Sorry, had to revisit this thread. Table worksheet > Column G is the additional requirement. Row 32-36 also new requirements. Data worksheet > Column F is the additional data Is there an easy way to incorporate the change into your code? Thanks, arv...

thread68-1803803 Hi Skip With new requirements, I need to extend beyond 12 months. Is there a quick fix to the code to cater to this? Thanks, arv

Hi I need help to take current year's value and populate in next year (but there is a dependency on the "day"). A1 - 01-01-20 - Wed = 1 (Wed is the Distribution Day) Plus 365 days later = 31-12-20 which is a Thursday. Will have to push to next Wed's date. Will require to do same for whole...

Hi Needing some help with excel. 1. What would be the formula to identify duplication/s in the table criteria. There might be 2,3,4 or more duplication especially with those in the ranges. 2. Once the number of matched records are identified, is there anyway to indicate which row/s the...

Seeking help around Excel formula. I have 3 combinations - A,B & C that are number ranges. I have broken them down into Lower and Upper. Numbers that fall within Range A, Range B and Range C will give the expected Outcome. Attached is an example workbook with subset of criteria. Thanks...

Hi Needing some help to filter by date and copy to new worksheet per month. - Add new worksheet for each month if data exist - If worksheet exist, delete and add new worksheet before copying data - If no data for the month, it will just move on to the next month Column B = Dates (Have defaulted...

Was wondering what might be the problem. I am trying to get external data from the web but it only returns 50 records. There are more records if i clicked on the arrow to Display More on the web page. Is there a way to extract full record on the excel worksheet? Thanks, Arv.