Dear Debraj Sir
Please find the following VB code :-
Sub copy_paste_data_from_one_sheet_to_another()
'Let's start at row 2. Row 1 has headers
x = 4
Dim myName As String
Dim myNameF As String
Dim cPart As Range
Dim Wk1 As Worksheet
Dim Wk2 As Worksheet
'Dim nextRow As Long
'Dim...
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...
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 300
rupa and sampa 400
sampa and sameer...
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...
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 only those column on which Stax not equal to...
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