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