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

    VBA code required for extract data from data sheet to another output sheet

    Respected All friends I am excel learner and want VBA code for extract data from data sheet to another output sheet if criteria matched from data sheet as sample file attache Please share vba code for the same Thanks & Regards Pabitra Roy
  2. roypabitra

    VBA code for extract data in condition mathced

    Respected All friends I am excel learner and want VBA code for extract data from data sheet to another output sheet if criteria matched from data sheet as sample file attache Please share vba code for the same Thanks & Regards Pabitra Roy
  3. roypabitra

    Delite Data through user form

    Respected Sir, Firstly I acknowledge to all of the forum members of my good wishes. I am navish in Excel VBA but trying to prepare small vba code for my office daily needs with the help of online help. Now I made our booking register through a user form where I could not delete the records and...
  4. roypabitra

    Copy Specified Range of a Sheet to Another Sheet

    Respected Sir I have a data file where have so many data , I Want to Copy specified specified Range to select and copy to another sheet a xls file have been attached for reference where two sheet one is Data Sheet and is Result sheet i.e. I want to copy range through vba from data Sheet...
  5. roypabitra

    Copy data in new sheet from list of data in a row of diffrent sheet if condition match

    Respected Sir, I have a data sheet like below : Note No. Date Name Bill No. 10522 12/04/2017 Jones 123/17-18 10523 18/04/2017 Ram 123/17-18 10524 22/04/2017 Shyam 126/17-18 10526...
  6. roypabitra

    select of tab name through data validation

    Respected Sir, How I Creat a Sheet name list through data validation where I select a Sheet and go to the selecting sheets. Please help me for the above Thanks & Regards Pabitra
  7. roypabitra

    Help on value error

    Respected Sir, I have a data file where I type so may data named salary2014-15.xls and the file have so many sheets aprl2015, may2015, june2015, ...... and also a sheet payslip now in payslip sheet at column g2 I entered my file name i.e. salary2014-15.xls and in column c12 in entered sheet...
  8. roypabitra

    Run Time Error 13 Type Mismatch

    Respected Sir, I have the following code which previously worked perfectly but now I got the Run time error 13 Type Mismatch. Please help me how to solve Sub copy_paste_data_from_one_sheet_to_another1() 'Let's start at row 2. Row 1 has headers x = 9 Dim myName As String Dim myNameF As String...
  9. roypabitra

    Data validation with combo box

    Respected sir, I have data sheet I a.xls file where I store different ledger name. Now I create a cash.xls file where I creat data validation with combo box , when I double click in data validated cell I select data by typing from a.xls file. After that I save the all file and close excel...
  10. roypabitra

    I have VBA code on which I can find a exact word and pest it another sheet but I

    Respected Debraj Sir please find the attach file and help me for the above http://www.fileconvoy.com/dfl.php?id=gf6bbe4fb63dd6000999246297d985acb5d4ee8c21 Thanks & Regards Pabitra
  11. roypabitra

    In Excel, how do I find one word in a set of text in a cell? and how to pest dat

    I have VBA code on which I can find a exact word and pest it another sheet but I want to search and pest not exact word like the following pabitra 100 rupa and pabitra 200 pabitra and sampa 30 rupa and sampa 400 sampa and sameer 500 sampa 600 rupa 700 now I want to copy data on which...
  12. roypabitra

    how to sum a column if criteria column # 0

    Respected Sir, I have two three column in a data sheet like the following TBA STAX TOTAL 100 2 103 200 0 200 300 10 310 400 0 400 100 5 105 Now sir i want to sum of TBA on which Stax not equal to Zero. Please Help me...
  13. roypabitra

    how sum figure of Indian format falue

    I have rupformat function and i convert number by rupformat like =rupformat(12345678) and now I want to sum three like this valu but its result shows #value Rs.12,54,875.00 Rs.24,58,769.00 Rs.3,96,54,781.00 #VALUE! please help me how I solve this problem
Back
Top