• 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

    Conditional Formatting

    Dear Sir, I wanted to Apply Conditional Formatting with comparing column to column. I wanted to compare Column A with Column B If the Value in Column A is greater than Column B then Up Arrow with brown Color. If the Value in Column A is lesser than Column B then Down Arrow with Blue Color If...
  2. S

    File Indexing

    Dear Sir, I have over 100 files and more than 10 folders in my PC. Like Bank statement in PDF. Accounting reports in Excel. Bank Letters and Word. I wanted to make a list of all documents in excel and give hyperlinks so once I click any document it should open. Please help me.
  3. S

    Finding Ledgers of Group.

    Dear Sir, I wanted to get the Ledger Group name in front of the ledger. For Example, Ledger Name is “ABCD BANK” and Group Name is Bank Accounts I want result Like Column “A” ABCD BANK and Bank Accounts in Column “B” Please Help.
  4. S

    Sales Dashboard

    Dear Sir, I wanted to make simple dashboard for Monthly sales Monthly Gross profit Monthly Gross profit % Product wise sales Salesman wise sales Salesman wise monthly sales Salesman wise gross profit report Salesman wise Gross profit % Product wise sales Product wise Gross profit...
  5. S

    how to convert numbers into words in excel?

    Dear sir, Its a same sheet but I didn't get any response for mail merge so I thought better to ask for excel help only and not for word. but if you can help me to do mail merge I will be thankful to you.
  6. S

    how to convert numbers into words in excel?

    Dear sir, can you please help to convert my amounts from numbers to words please?
  7. S

    excel amounts convert into word and mail merge.

    Dear Sir, I have excel sheet where I have customer name /currency/amount/location and date. I wanted the amount to be converted into words and do the mail merge as per attached letter format. Can you please help.
  8. S

    comparing two excel sheets.

    Dear Sir, Its great formula, I could not even think about such a big formula for solution, where can I understand how this formula is written because for me to practicing this formula some guidelines required, I can pay consultancy if required to understand this formula.
  9. S

    comparing two excel sheets.

    Dear Sir, Thanks, can you please tell me, how can I learn to prepare this reconciliation any video or guide can you please share?
  10. S

    comparing two excel sheets.

    Dear Sir, I have two sheets 1) Bank Statement 2) Bank Ledger My data is not in a same format I wanted to reconcile both sheet and highlight the matching cells with color yellow amount difference with up to Rs 1 can be ignored. I have been trying to solve this type of problem since years because...
  11. S

    HTML to Excel

    Dear Sir, My accounting software doesn't generate bank ledger into excel it generates either pdf or HTML what can be done to convert it into excel from html because I tried pdf to excel it doesn't come properly in excel lot of manual work required amount comes in below the dates in some cases...
  12. S

    Customer Collection due date reminder report.

    Dear Sir, I wanted your help to make customer collection due date reminder. Customer name Expected Amount Due date Received amount If due date is 20-11-2022 then on 19-11-2022 that column should be orange as before due date. If due date is 20-11-2022 then on 20-11-2022 that column should be...
  13. S

    Making bank summary in excel.

    Dear Sir, I have large set of EMI repayment files I wanted to make summary as per sheet2 based on sheet1. Please help.
  14. S

    Combine Formulas

    Dear Sir, output is correct but I didnt understand anysingle line of the formula, can you just help me combine the mutiple formulas like (&,countif,lookup) in single column.
  15. S

    Combine Formulas

    Dear Sir, I wanted to combine formulas in single formula please help. Helper1 from column D Countif from column E Helper2 from column F Lookup from column G Instead of using multiple columns can I combine all four formulas in single column.
  16. S

    Coloring two sheets.

    Dear Sir, I have two sheets; one is tally and another one is tally1. Tally is colored and tally1 is non colored. I wanted to apply formula or solution to give same color for the same item is available in tally1. For example: tally sheet has 09-08-2019 Receipt 311784 20800.00 which is colored...
  17. S

    Dates

    Dear Sir, Thanks for your reply. I wanted to get result like highlighted in yellow but it’s not coming.
  18. S

    Dates

    Dear Sir, I wanted to convert my data to dates as (DD-MM-YYYY). Please help as its not getting converted.
  19. S

    Dashboard company as executive dashboard

    Dear Sir, I wanted to make one dashboard for my company's performance report which needs to be made from beginning. Dashboard will include monthly performance report and vehicle report. I can pay service fees please let me know how can you help.
  20. S

    sending email from excel

    Dear Sir, When I send from my sheet its not working can you please check ?
  21. S

    sending email from excel

    Dear Sir, I tried below VBA code but it sending selected worksheet as attachment I wanted to send as range from outlook, I am using office 365. Please advise. >>> use code - tags <<< Sub Mail_Range() 'Working in Excel 2000-2016 'For Tips see...
  22. S

    Making table of all files

    Dear Sir, I want an excel macro which will make list all file from a particular folder then I can click on the name of that file and get access to that particular file.
  23. S

    sending email from excel

    Dear Sir, I wanted a macro for sending email like selected part of excel with customized message which will save my time to copy and paste from excel to outlook.
  24. S

    Conditional Formatting

    Dear Sir, I wanted to highlight those which are matching with reference number and amount with color ‘YELLOW” Difference upto Rs 2 can be ignored (excess or less) If Voucher number is matching but amount is not matching wanted to color “BLUE” If Voucher number is not matching then wanted to...
  25. S

    Combine Excel Files.

    Dear Sir, I have 300 daily sales report excel files, I wanted to combine them into one using VBA how to do that ? please advice.
Back
Top