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

    Externa links - the original formula is being replaced with the external link

    Hi, I have two workbooks. In Book 1, Cell C11, the formula is =C124. In Cell C 124 of Book 1, the formula is = 'https:///personal/Test_com/Documents/Documents/[Source.xlsx]Sheet1'!$B$5 I then save and close both files. When I open book 1, Cell C11 formula is replaced with...
  2. S

    Personal macro that Hides rows based on criteria in column A

    Thank you for this. I created a new excel work book, clicked on the developer tab, clicked on record macro and named and saved this file as Personal.xlsb Then I opened the personal workbook again and clicked on the developer tab, VBA project and selected module 1 and pasted the code here. I...
  3. S

    Personal macro that Hides rows based on criteria in column A

    Apologies in advance and please excuse my stupidity. I am failing dismally at trying to do this. What does designation mean? I have attached the file. The other 3 files have a similar layout in that column A will either resolve as Show or Hide.
  4. S

    Personal macro that Hides rows based on criteria in column A

    I have 4 workbooks. Column A of all 4 workbooks has a calculation which determines if the row should be hidden or not. Each workbook has about 40 sheets. I would like to record a personal macro that is able to run for all 4 workbooks so that I can hide the rows which need to be hidden. I...
  5. S

    Data validation list with a search/filter option

    Hi, Please assist with a solution for creating a data validation list which has a data filter/search option. Attached is my file. The data validation list is in column C. Below is a standard data validation cell:
  6. S

    If then formula

    Thank you so much. This worked perfectly. Do you by any chance know how to do the following: - i have used sumif to extract information in my balance sheet - how do I reclassify credit accounts which are in debit to automatically post to accounts payables.
  7. S

    If then formula

    Hi Narayan, Are you able to see my file? Cell O7 is linked to the cover page where it defines the period number and month. If O7=period 5, then the formula must sum B8:F8.
  8. S

    If then formula

    I am comparing the budget YTD vs Actual YTD. if I am in period 5 of the year, how do I get only the sum of the first 5 columns to display in the budget YTD column. If N7=5, then sum B8:f8
Back
Top