• 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. Niranjanrajrishi

    VBA code to Group with positive numbers in Pivot and create sheet with the same data.

    Sorry! I didn't get the method you suggested. Can you please help with more details?
  2. Niranjanrajrishi

    VBA code to Group with positive numbers in Pivot and create sheet with the same data.

    Wow! It works with the filter. lRow As Long - shows the error "statement invalid outside type block". When I ran the code without the statement it worked. is it fine? The option to move only positive values (filtered data) does not seem to be correct as it shows the entire data in the Data sheet...
  3. Niranjanrajrishi

    VBA code to Group with positive numbers in Pivot and create sheet with the same data.

    Apoligizes if the requirement was not clear. I created new sheet "Result of group" which I created after grouped all positive amounts. So I am looking to get the coding for the same. Please let me know if it doesn't help.
  4. Niranjanrajrishi

    VBA code to Group with positive numbers in Pivot and create sheet with the same data.

    Hi, Would like to seek support to complete my VBA code to create my report. I have completed the data formatting and pivot table creation. Now I need to sort the Pivot table with values and create group for positive amounts (the data has both positive and negative values). Once the group is...
  5. Niranjanrajrishi

    PivotTable error

    Thank you....it was the version error and resolved when we upgraded to 2016.
  6. Niranjanrajrishi

    PivotTable error

    ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:=Pivotrange, Version:=xlPivotTableVersion15).CreatePivotTable TableDestination:="Sheet1!R3C1", TableName:="PivotTable1", DefaultVersion:=xlPivotTableVersion15 Hi, Need help with the attached code. The code to generate Pivot...
  7. Niranjanrajrishi

    Filter with multiple values contains

    Thank you. It worked!
  8. Niranjanrajrishi

    Filter with multiple values contains

    Hey, Hey, This code works perfectly when the data exists. After filter, if there is no data then it shows error at "Range("N:N").AutoFilter 1, .Keys, xlFilterValues".
  9. Niranjanrajrishi

    Filter with multiple values contains

    Hey, thanks for the question. I am trying to filter the text which starts with O, S, L, M, N. Does it help?
  10. Niranjanrajrishi

    Filter with multiple values contains

    When you say SPLIT, use same coding for 3 times (1 code for first 2 letters, then 2nd one and lastly one letter)?
  11. Niranjanrajrishi

    Filter with multiple values contains

    Hello, I am trying to create a code wherein the N column needs to be filtered with the cell values starting with "O", "S", "L", "M", "N". I tried with ARRAY but it does not work if the items are more than 2. Can you help me here to find the correct code? Regards, Niranjan
  12. Niranjanrajrishi

    CountiF - within particular date range

    Hi, I am trying to prepare a report of work items for each day of the month. I made the inflow, outflow with countif formula. I am stuck with the pending items on each day. My criteria is if there are any items with Open status (Column D in the Data sheet) and Column E (Data sheet) is blank and...
  13. Niranjanrajrishi

    Consolidate 3rd worksheets of each workbooks

    Thank you so much! I tried and it allows me to select only one file at time. Can you please make it multiple file selection option? Also when I tried with 2 files, I could not see the output file. Is it something on the same sheet or new workfile?
  14. Niranjanrajrishi

    Consolidate 3rd worksheets of each workbooks

    Please see below the answers: Is it matter which order are those worksheets? - Input file always carry 3 sheets and 3rd sheet is the data sheet which needs to be consolidated. So it does not matter the order to consolidate. In any order we can consolidate. = if order of worksheets can change...
  15. Niranjanrajrishi

    Consolidate 3rd worksheets of each workbooks

    For each work worksheets, the data to be consolidated will be in the 3rd sheet (will be the last sheet of each workbooks). The concern here is that they do not carry same naming convention. The sheet name will be different and those prepared by multiple parties. The only trick here is to...
  16. Niranjanrajrishi

    Consolidate 3rd worksheets of each workbooks

    Hello, Can you help me to find a code to consolidate every 3rd worksheets of multiple workbooks? The workbooks can go up to 20 and option to select the workbook at code running would be a nice option. I searched in the net and got some coding but it does not help me to consider 3rd worksheet...
  17. Niranjanrajrishi

    Create workbook with 2 sheets based on the sheets

    Hi, Would like to seek help to create workbooks based on the sheets available. For each worksheets we need to consider the first 4 letters and create one workbook with 2 different sheets. For example: we have 2 sheets "5A00" and 5A00 - Parked". These 2 sheets should be created as one workbook...
  18. Niranjanrajrishi

    Create workbooks based on values in 2 column values

    Thank you so much! It worked perfectly.
  19. Niranjanrajrishi

    Create workbooks based on values in 2 column values

    I ran the code and it worked for Direct cases. For Indirect, new workbood did create but all workbooks were emplty. No data copied to Indrect workbooks.
  20. Niranjanrajrishi

    Create workbooks based on values in 2 column values

    Yes...thats the perfect thought. I am trying to create sheets based on 2 column values. So BA Direct and BA Indirect should create 2 workbooks.
  21. Niranjanrajrishi

    Create workbooks based on values in 2 column values

    I appreciate your efforts to support me. I ran the code but it does not create sheets based on the 2 criterias mentioned in the initial request. Am I missing something here? The first file generated for 5A but it includes both Direct and Indirect. I am trying to get the files generated for...
  22. Niranjanrajrishi

    Create workbooks based on values in 2 column values

    Apologizes for the delay to come back to you. Where did you save the coding? I opened the file which I see the same coding and it does have any coding to select the folder "TestFolder".
  23. Niranjanrajrishi

    Create workbooks based on values in 2 column values

    Thank you so much. I will test it and let you know.
Back
Top