you can,In all the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -
>
> --
> *From:* Nur Hossain
> *To:* excel-macros
> *Sent:* Wednesd
you can,By all the means you can,In all the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -----
>
> --
> *From:* Nur Hoss
Dear all , I am having a text strings which is separated by underscore ( _ )
.please remember numeric number may vary more or less
CELL A1= 10.20.193.49_255.255.255.240_1503
It need to be separated like below CELL wise form CELL A1
CELL B1= 10.20.193.49
CELL C1= 255.255.255.240
CELL D1= 1503
aces you can,
> At all the times you can,
> To all the people you can,
> As long as ever you can.” - John
> Wesley
> ---------
>
>
>
>>
>> From: Nur Hossain
>>To: excel-macros@google
Dear all,
Would you please spare some time to understand the attached macro
code line by line with details each single parameters explanation ?
. though it has short heading but still I am confused , what
actually did the each line along with its single parameter also .
--
Are you =EXP(E:R
Dear all,
Would you please spare some time to understand the attached macro
code line by line with details each single parameters explanation ?
. though it has short heading but still I am confused , what
actually did the each line along with its single parameter also..
--
Are you =EXP(E:R
Dear all, I am having two sheet ,need to copy particular data range of
“input sheet” and past to “output sheet “ conditionally . here my
data range of input sheet is A1:E8, F1:J8,K1:O8 . this range need to
past to the output sheet in the column rage A:E , I have attached my
excel sheet & also s
Mandeep da,
Your UDF function is working fine. it is really nice concept that you
did. thanks once again for your valuable time regarding my issue.. i
also got a solution from Paul .though currently i did not get any
problem, then now i analysis whether any discrepancy is there or not
.. if i get
---------
>
>
>>
>> From: Nur Hossain
>>To: excel-macros@googlegroups.com
>>Cc: Paul Schreiner
>>Sent: Thursday, November 20, 2014 7:47 AM
>>Subject: Re: $$Excel-Macros$$ Extraction desire text data from the cell by
>&g
you can,
> In all the places you can,
> At all the times you can,
> To all the people you can,
> As long as ever you can.” - John Wesley
> -----
>
>
>>
>> From: Nur Hossain
>>To: excel-m
Mandeep da,
Take my respect ,yes you did excellent job for me . the formula
results are 100% correct . please take time for solving % issue. Is
it possible to implement reference text inside the formula . if not
possible then use another column to keep the “ reference text “ , it
might be colu
Dear all, I need to extract the partial contents of a cell. My excel
sheet contains the data in the cell A:A which is very complex format
data . form this data , I want to get the data as I color marks form
B2:G2. Please check the attachments. If I get any partial help I will
be glad also ..
--
is here working through me for you.*
>
> On Sun, Oct 5, 2014 at 9:58 PM, Nur Hossain wrote:
>
>> Dear all , I was using attached macro since last few months . and I
>> didn’t
>> get any problem . but today while I am going to run this macro it shows
>> error like.
Dear all , I was using attached macro since last few months . and I didn’t
get any problem . but today while I am going to run this macro it shows
error like.
Run Time error ‘1004’:
If I press debug then it goes to below line
.Refresh BackgroundQuery:=False
Would you please check the macro as a
Hi Joshi Da , Yes it works perfectly , You did very nice job for me
. it will help me a lots . thanks for your kind help ..
On 8/24/14, Vaibhav Joshi wrote:
> Hi
>
> Check this...
>
>
> Cheers!!
>
>
> On Sun, Aug 24, 2014 at 8:12 AM, Nur Hossain wrote:
>
>
Dear All , My previous attached file was wrong. here is the update file.
On 8/23/14, Nur Hossain https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
Dear all, I am having data like below in the cell A & B in the sheet input
cell A cell B
Tra Code:RNSPIN
News:what ever it is
PDate: 8/5/2013
Expire Date: 8/12/2013
Tra Code:BD NEW
News:what ever it is
PDate: 8/5/2013
Expire Date: 8/12/2013
Tra Code:CS N
“Do all the good you can,By all the means you can,In all the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -
>
>*From:* Nur Hossain
> *To:* excel
Dear all, I am having an “Excel Macro Enable Workbook” & it works very
well. Now if I save as it to “Excel Binary workbook “ . or save as it
as normal “Excel workbook” only . in both case it works as well . but
my question , is it mandatory to keep the excel workbook as macro
enable where its havin
Joshi da,it works perfectly , thanks for your help
.
On Fri, Aug 1, 2014 at 1:45 PM, Vaibhav Joshi wrote:
> PFA
>
> Cheers!!
>
>
> On Thu, Jul 31, 2014 at 11:52 PM, Nur Hossain wrote:
>
>> Dear all, Data separation by formula
>> CELLA having data like belo
Dear all, Data separation by formula
CELLA having data like below
3RB2 AIS 130719 13414056RB2RDI
140619 124341872RB2 LOFYT
130619 1543466589RBL2LOS 120519
114346KL5252B NONE
Dear all, I need all of your assistance to solve my query . on daily basis
I am to do it manually that is time consuming & boring for me . it helps me
if I get any macro solution . please check the attachment , here I have
shown what I exactly I want by color mark.
--
Are you =EXP(E:RT) or =NOT(
ange("A1")
>
> Cheers
>
>
> On Tue, Jul 29, 2014 at 4:11 PM, Nur Hossain wrote:
>
>> Joshi da , only last row of column A
>>
>>
>> On Tue, Jul 29, 2014 at 4:35 PM, Vaibhav Joshi wrote:
>>
>>> What you mean by used range?? You me
Joshi da , only last row of column A
On Tue, Jul 29, 2014 at 4:35 PM, Vaibhav Joshi wrote:
> What you mean by used range?? You mean upto only last row of column A or
> the last column of sheet??
>
>
> On Tue, Jul 29, 2014 at 3:55 PM, Nur Hossain wrote:
>
>> Dear all ,
Dear all , Below code inside macro is working fine for my case
Sheets("input").Columns("A:A").Copy Sheets("output").Range("A1")
but for some issue I need a macro that copy only used Range except
whole *Columns("A:A")
* of the “Input “ sheet to “output” sheet
--
Are you =EXP(E:RT) or =NOT(EXP(E:
Dear Amit Da, it works perfectly. thanks for helping me..
On Tue, Jul 29, 2014 at 11:57 AM, Amit Desai (MERU) wrote:
> Please see if this helps..
>
>
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Nur Hossain
&
Dear all, I need data separation by formula , please check the attachment.
I have shown color mark that need to separate from column A to column B, C,
D onward. like below :
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebo
It also works , thanks Ravi da
On Mon, Jul 28, 2014 at 1:24 PM, Ravi Kumar wrote:
> another way
>
> =CHOOSE(MATCH(A1,{"red","sta","ida","pco","pid","pde"},0),"us2","ru2","cu2","us3",&q
o","us3";"pid","ru3";"pde","cu3"},2,0)
>
> Cheers!!
>
>
> On Sat, Jul 26, 2014 at 9:22 AM, Nur Hossain wrote:
>>
>> Dear all , how to merge following six formula into single formula.
>> small formula is required
Pco","Us3",IF(A1="Pde","Cu3","")
>
>
> Regards
> Pramod
>
>
> On Sat, Jul 26, 2014 at 9:22 AM, Nur Hossain wrote:
>>
>> Dear all , how to merge following six formula into single formula.
>> small formula is requi
Dear all , how to merge following six formula into single formula.
small formula is required . Thanks
IF(A1="red","us2","")
IF(A1="sta","ru2","")
IF(A1="ida","cu2","")
IF(A1="pco","us3","")
IF(A1="pid","ru3","")
IF(A1="pde","cu3","")
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do
it's relay effective code..nur
On Tue, Jun 25, 2013 at 11:02 AM, VBA VABZ wrote:
> Hi
>
> PFA file that take care of coping data.
>
> HTH//Vabs
>
>
> On Mon, Jun 24, 2013 at 7:41 PM, wrote:
>
>> Hi All!
>>
>> My name is Ryan. I am pretty experienced in Excel but have run into a
>> dead in wit
32 matches
Mail list logo