• 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

    Ohhh I see.. I removed and it's resolved, thank you so much.
  2. 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...
  3. 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.
  4. S

    Project Unviewable

    Thanks.
  5. S

    Project Unviewable

    Password not remember. Then what can we do ?
  6. S

    Project Unviewable

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

    VBA help edit/update userform help

    Thank you , So much SirJB7 now this workbook working with my request ... thanks a lot
  8. 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...
  9. S

    VBA help

    Yes sir
  10. S

    VBA help

    Dear Sir Thank u so much, but here a problem that ... when i enter second entry by same id ( for example id no : 1) in data entry sheet then sheetname 1's entry increasing , it should not to be .
  11. 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 )...
  12. S

    VBA help in data entry sheet

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

    VBA Help

    Dear Chandoo ! Please find the link . need vba help please your concept will clear after see file . I want to here for modify above coding if I enter id no 1 in this data entry sheet then its data (a2:f4) comes in sheet name 1 if i enter id no 2 in this data entry sheet then its data...
  14. 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
  15. S

    VBA Help

    Thanks SirJB7........... I assume that ........ first condition : sheet2's cell B1 is "1" then sheet2's A1 cell's data transfer in sheet 3 in A1, same condition is here second condition : sheet2's cell C1 is "2" then Sheet2's A2 cell's data transfer in sheet 4 in cell A2 is this possible ?
  16. 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...
  17. S

    ENTER DATA SHOULD NOT DELETE

    Dear All, Anybody can help me ?
  18. S

    ENTER DATA SHOULD NOT DELETE

    Dear all, Can u help me in above question ?
  19. 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
  20. S

    ENTER DATA SHOULD NOT DELETE

    Dear Sir, You have given me macro code for data should not delete after entry I have a data entry form and i want to its details in different 5 sheets Please find the link i write my question's in this sheet https://docs.google.com/open?id=0B6VY6rBw3NuBcEhUSWtiS3RJZWc
  21. S

    Inter Office Memo Generate By data entry

    Hi All, have read this ?
  22. 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
  23. S

    Error in save document , Privacy warning :

    Yes i have 2007 excel and i try to save it in 2007 excel
  24. 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 ...
  25. S

    Formula Need

    Dear Sir, I am thank ful to you . you have given solution is right , but i want to in this report file i will enter date from___to____ after i want generate report of fund amount of all below sheet ( which is in code ), REPORT GENERATE BY DATE WISE i only give you example here , is there...
Back
Top