• 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

    Error - Import images in excel

    Dear All, Hope you all are well!! Subject: I am getting an error to importing images (An error occurred while importing this file. D:\A Suresh 2022 New Data\2022 New Data_Ariane_Suresh\Low_Resoution_Images/AMKARN0000.png) Below is the code which i am Using. >>> use code - tags <<< Private...
  2. S

    Remaining Balance

    Dear Sir, Please find attached sheet. Query : I want to put formula in E column. Date Credit Withdrawal Remain. Balance 21/01/18 100 0 22/01/18 200 300 300 IF I WITHDRAWAL ON 22-01-2018 THEN ABOVE BALANCE WILL ZERO in remain. Balance column.
  3. S

    Project Unviewable

    Dear Sir, My excel file is protected with password, error show in vba (Alt+f11) is "Project Unviewable"
  4. S

    VBA help edit/update userform help

    Dear Sir, Please find the attached file of data entry userform. https://docs.google.com/open?id=0B6VY6rBw3NuBRF92Qmt6MlpaQlU you will find in sheet two buttons 1. Add data and 2 . Edit / Update data My question is that ... In edit/update data userform, when i click button update record...
  5. S

    VBA help

    Dear All, I have created a column as id number, Sheetname "Dataentry"'s rows data will transfer in same id number's sheets ( other sheets name i given as ID ) Cell A1 = 1 ( 1 is id number ) Cell A2 = 2 ( 2 is id number ) Cell A3 = 3 ( 3 is id number ) Cell A4 = 1 ( Repeated id number )...
  6. S

    VBA help in data entry sheet

    Dear Chandoo, Please find below link https://docs.google.com/open?id=0B7ZSslDZMRaQTFNRUHRTRE5nd0E
  7. S

    Max Value found

    A B C D A1 1 10 1 =answer here A2 1 20 A3 2 5 A4 2 6 As per above data we required result in D1 Cell. Maximum value according to C1 cell from B column , in sort . C1 = A1 then answer B2 (20) means maximum value
  8. S

    VBA Help

    i want to get data in sheet3 of sheet2 Please modify below coding Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Range("sheet2")("A1:A25")) Is Nothing Then Exit Sub Application.EnableEvents = True If Range("sheet2")("A1") &#60;&#62; "" Then...
  9. S

    Month calculate from a date in point

    Dear all, I have a date 1-jan-2010 i want to calculate month, day and year till today from above date , i want to result in point means 1 and half = 1.6
  10. S

    Inter Office Memo Generate By data entry

    Dear All, I have uploaded a file , please find the iom sheet , you will my questions in this sheet https://rapidshare.com/files/2804026139/Inter_Office_Memo.xlsx
  11. S

    Error in save document , Privacy warning :

    I have save file as macro but error shows Privacy warning : this document contains macros, Active X controls, xml expansion pack information or web components , These may include personal information that cannot be removed by the document inspector. Macro VBA code can not work in this file ...
  12. S

    Formula Need

    Dear Sir, Please find the link , i need formula help https://rapidshare.com/files/2571544105/ACCOUNT_DATA.xlsm Please open the file and find question in report file sheet
  13. S

    Back up of Excel file

    Dear All, how we can take every day back up of excel file ?
  14. S

    Need formula help

    I have uploaded file in google document and share with id chandoo.d.gmail com
  15. S

    Need Formula

    Dear Sir, Please find the link https://rapidshare.com/files/3785902112/Questions.xlsx Need formula help
  16. S

    Dear Narayank 1026

    Dear Sir, I have sent you a mail on narayank1026(at)gmail(dot)com this id i want to help .
  17. S

    COMMENT PRINTING

    Dear Sir, I have a file of attendance sheet. I narrated each cell comment , now i want print with all comment how its possible ?
  18. S

    AMOUNT ENTRY

    Dear Sir, if i entry in cell A1 , =(100+200+300+400+500) then answer will shows 15,000 in same cell. my question is that , when i entry in cell A1 same like =(100+200+300+400+500) and i want in sheet 2 same this entry as A1 IN 100 A2 IN 200 A3 IN 300 A4 IN 400 A5 IN 500 is this...
  19. S

    LOCK OF INSERT SMART ART

    Dear Sir , Good morning to you all, when we add in sheet insert menu - smart art - any image or shape CAN WE LOCK SMART ART ? BECAUSE NO BODY CAN CHANGE IT
  20. S

    Jpg image to excel

    Dear All, I have jpg image of some persons's name Is there possible convert jpg to excel ?
  21. S

    Hour Caclulation

    Dear All, In A1 is 8:30 AM then B1 is 01:00 AM after D1 answer is 7:30 hours, this is wrong so please help me how can i calculate of total hour worked ?
  22. S

    and # formula how its work ?

    Dear Sir, I want to know that , why we are using "&" and "#" (this format) in formula ? how its work ?
  23. S

    Need Formula for Many person&#39;s account handle

    Dear Sir, Please find the link , i need help of formula https://rapidshare.com/files/4204386410/formula.xlsx
  24. S

    ENTER DATA SHOULD NOT DELETE

    Dear Sir, if i write below formula in cell b1, when i delete entry of a1 then b1 should not be delete =IF(a1="","",a1)
  25. S

    LOCK AFTER ENTRY IN CELL

    Dear Sir, Please help me in vba can i lock a cell after enter data ?
Back
Top