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

Recent content by balaji3081

  1. balaji3081

    Copy multiple cells from row& column header intersection

    I have attached the files for refernace - I am need of getting the specific row and column from the 4 product files ( the row and column headers has been called out in the Summary file). Hope teh sample file makes it easier for coding purpose. Thanks
  2. balaji3081

    Copy multiple cells from row& column header intersection

    Sure will try to make some data sample and post it here
  3. balaji3081

    Copy multiple cells from row& column header intersection

    Appreciate if any help can be provided, Thanks
  4. balaji3081

    Copy multiple cells from row& column header intersection

    Hi All - I am looking for a macro to extract data from multiple (15+ excel files) data file basis an intersection of row col header which is pre defined in the summary file. In the Data file the row & col headers are same for all (15+) files for a given month, in my summary file criteria keeps...
  5. balaji3081

    Macro to copy paste & close cell values from multiple files

    Thanks, I have been not very active and surely creating confusion for all. Giving it a last shot To put it simply I am trying to get value from 5 different files in a recon file one below the other. The source file is = LOB1/2/3/4/5 - prefer to select the folder and the file names can be...
  6. balaji3081

    Macro to copy paste & close cell values from multiple files

    I don't think I understood your earlier reply, I will ask this question in the right forum (under VBA)and with more details. Thanks
  7. balaji3081

    Macro to copy paste & close cell values from multiple files

    Hi Marc - With the above solution I can only open and copy one file at a time. Instead I need is to work in loop for all the files I have listed.
  8. balaji3081

    Macro to copy paste & close cell values from multiple files

    Hi All, I have to reconcile two sets of files in different folders on a monthly basis, currently I open each file apply filter if required and paste value in the recon file. Takes a long time manually. I have attached a template , where - - Folder path is mentioned in cell C3 & O3 - File...
  9. balaji3081

    Conditional Formatting of Previous Row , Based on cell value

    I have a further question, Is it possible to align the subtotals as left and the rest with one space in the beginning.
  10. balaji3081

    Conditional Formatting of Previous Row , Based on cell value

    I got the solution to that by using Accounting Format.
  11. balaji3081

    Conditional Formatting of Previous Row , Based on cell value

    I see that the underline condition is only to the list of the number in the cell, is there a way to extend it to the complete cell width?
  12. balaji3081

    Conditional Formatting of Previous Row , Based on cell value

    Awesome, Thanks a ton, I will apply to my file.
  13. balaji3081

    Conditional Formatting of Previous Row , Based on cell value

    Hi All, Is it possible to format (Underline rows) previous rows based on cell values in a column using Conditional Formatting. A B C C D 1 Mango 5.7 11.5 10.5 3.4 2 Banana 0.3 0.3 0.3 3.4 3 Apple 0.7 0.7 3.7 3.4 4 Fruits 6.7...
Back
Top