• 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. 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...
  2. 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...
  3. 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...
  4. balaji3081

    Hide rows macro to run after a event

    Hi All, I need the hide rows macro to run after the selection is made from a drop down list, which will trigger the change in value in column AE, currentl;y I have to run it using Alt +F8. Please advice. Sub HideRows() BeginRow = 1 EndRow = 100 ChkCol = 31 For RowCnt = BeginRow To...
  5. balaji3081

    macro to format row based on cell value

    Hi All, I am trying to get a two rows formatted based on the value in the range, my code has a event worksheet_change which is disabling my excel undo function, I am not at all comfortable with this, is there a better code to give me the result - Below is the code I am currently using -...
  6. balaji3081

    Macro to replace Image, Numbers in Table and in multiple protected word document

    Hi All, I am struggling at this, I have received 200 word documents for which I need to make set changes on all, Below are th changes requested - NOTE : All Word Documents are password protected, and after the changed are made need to be saved as current month - 1 - Logo to be replaced...
  7. balaji3081

    Sum if get the value from one column based on the criteria from different columns

    Hi There, I am struggling with this, I am looking for a formula to get the Amount based on channels coming from different columns, As in the attached file - I need the sum if formula for getting the amount for each Channel , which is based on the data from Different Columns.
  8. balaji3081

    Getting access data using parameters in Excel

    I love this, this is my 3rd thread in 24hrs.... I have a template which I have attached, this has macros to pull data from a particular query and makes a file for each country based on the Base file, thanks to the members here I was able to reach till here now in addition to what i already...
  9. balaji3081

    Previous month

    Hi, I have a period column which has 12 months rolling period in yyyymm format (201210 - 201309), I need two columns YTD and MTD, based on what is there on the period column teh YTD and MTD should auto calculate , Don't want to use any reference cell apart from what is there in the period...
  10. balaji3081

    VBA Code

    Guys need help, not sure if this is enough or you need more details - Public oApp As Object Public strDB As String Public Wbk_Base As Workbook Public strPDF As String Public Sub Initialize() Application.DisplayAlerts = False strDB = Worksheets("Input").Range("B2") 'strPDF =...
  11. balaji3081

    Save data source macro

    Hi, I have recorded a macro to save the data source in the background of three pivot tables, The macro is too specific to the three pivot I have, is there a way that it works on any pivot Sub Pivot() ' ' Pivot Macro ' save data source ' ' Keyboard Shortcut: Ctrl+e '...
  12. balaji3081

    Need a sample WIP Expense file....

    Hi Guys, Not sure if this is the right forum, Do let me know will re post. I am looking for a Sample WIP Expense file, showing Expenses by current month actuals , CY YTD Actuals , MTD Actuals VS MTD last year, and CY YTD vs LY YTD. Rgeards, Bala
  13. balaji3081

    Pivot data range needs to be constant

    Hi, Below is the Macro I run - To create a copy of the base file and to get the required data and deleting the rest, and refreshing the pivots, this work really great, thaks to debraj (excel Ninja). Coming to the point - the new file created has three pivots , and the range it has is of the...
  14. balaji3081

    Macro on Personnel.XLSB gets deleted...Need help

    Below are the two Macros I am trying to save on Personal.XLSB, its runs fine, once I close the excel application, and reopen, the macro is gone.....Am I doing something wrong, this is the first time I am working on Personal.xlsb..... 1) The code below is to get the number in the selected cell...
  15. balaji3081

    Classic Pivot View

    Hi Guys, Here is a macro to for getting to the classic view on pivot via a shortcut(Ctrl+r). however the macro has made the pivot very specific to Pivot table 8 , I want it to work for any pivot. Sub Classic_Pivot() ' ' Classic_Pivot Macro ' to convert to classic view ' ' Keyboard Shortcut...
  16. balaji3081

    delete rows from multiple tabs if cells in specific column is blank

    Hi, Need urgent help is this, have to submit the file by monday - this is how I have the file - On the 'Main' tab there to list criteria's which need to be selected, once selected the formula in the rest of the tabs (Actuals, Budget,Headcount,LY Actuals) marks the relevant rows. Now I need a...
Back
Top