Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: arvarr
  • Content: Threads
  • Order by date
  1. arvarr

    Excel Formula Help

    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...
  2. arvarr

    Excel - getpivotdata function

    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...
  3. arvarr

    Excel Formula

    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...
  4. arvarr

    Rename Connection Name (Data Connection)

    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...
  5. arvarr

    Pivot Table - Calculated Fields / Different From

    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...
  6. arvarr

    Variable in Pivot Table

    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...
  7. arvarr

    Excel - getpivotdata function

    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...
  8. arvarr

    Pivot Table drill through in a new workbook

    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
  9. arvarr

    Excel Help - Worksheets by UserID

    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...
  10. arvarr

    Excel Help - Worksheets by UserID

    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...
  11. arvarr

    Excel - Filter Help

    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...
  12. arvarr

    Excel VBA - Restrict one or multiple worksheets / slicers for users using password

    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...
  13. arvarr

    Excel - Data input

    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...
  14. arvarr

    Formula Help

    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...
  15. arvarr

    Copy data from one worksheet to multiple worksheets

    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
  16. arvarr

    Excel - Find Date/Days to use the values

    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...
  17. arvarr

    Excel Formula Help

    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...
  18. arvarr

    Excel Formula Help

    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...
  19. arvarr

    Filter by Date and Copy to New Worksheet

    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...
  20. arvarr

    Getting Data from Web into Excel

    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.

Part and Inventory Search

Back
Top