Search results

Respected Sir, I need only VBA only Regards Pabitra Roy

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

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

Respected Charlesdh I want to copy the data to another sheet in criteria matched

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

Yes Sir

Yes Sir, if criteria starts from ABC Ltd and copied all the row upto customer total of end of ABC Ltd a

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

Thanks All to assist me

Respected Sir, Thanks for your prompt reply But when I clear the filter the formula is not working properly. is it not possible through VBA code? If yes please assist me how to implement it. Thanks & Regards Pabitra

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

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

Respected Sir, So many thanks to you Thanks & Regards Pabitra Roy

Respected Sir, So many thanks to you and it works perfectly. Again Sir again I have a question if I want to copy the same form another file then how to apply the formula. Please assist me Thanks & Regards Pabitra Roy

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

Dear All my Friends and Master, When I get the error and debug then open the VB and cursor goes to Do While Cells(x, 8) <> "" So I think error on Do While Cells(x, 8) <> "" Thanks & Regards Pabitra

Respected Sir, As desired by you I am trying to uploading the actual database file but it fails to uploaded due to uploaded file is too large. Thanks & Regards Pabitra

Excel Learner

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

Respected SirJB7 Congratulate you on 4000+ post!!!!!!!!! also we expected more post from you. Thanks & Regards Pabitra

Respected Sir, Sir, But I work in only excel-2007 I never work in Excel-2010 but I save the file as .xls format. So, Sir, It is possible to keep the data validation after saving the file. Thanks & Regards Pabitra Roy

Respected Sir, Thanks for your opinion and next time I should remember it. Thanks & Regards Pabitr

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

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

Respected Sir, As when we change the line "if INSTR(Cells(x, 8),myName,1)&#62;0 then" instated of "If Cells(x, 8) = myName Then" it shows error code 13 type mismatch and request you please advice me how to attach this worksheet file. again I posted the VBA code for further reference Sub...