use this:
Sub Reporting()
Dim abc As Long: abc = Sheet1.Range("A" & Rows.Count).End(xlUp).Row
Sheet1.Range("B7:B" & abc).FormulaR1C1 =
"=IF(RC1=,,TEXT(RC1,""mmm"")&""-""&TEXT(RC1,""yy""))"
End Sub
*Pankaj Sharma *
*MIS Analyst*
see if it helps
On Sun, Aug 26, 2012 at 9:40 AM, hemant shah wrote:
> Dear Experts,
>
> I haven't yet received solution for my query below.
>
> Please help.
>
> Regards,
>
> -- Forwarded message --
> From: hemant shah
> Date: Sun, Aug 19, 2012 at 12:56 PM
> Subject: Need help
Dear Experts,
I haven't yet received solution for my query below.
Please help.
Regards,
-- Forwarded message --
From: hemant shah
Date: Sun, Aug 19, 2012 at 12:56 PM
Subject: Need help on a formula
To: excel-macros
Dear Experts,
I am stuck up which my work in an excel. I n
> Wishing you a great day!
>
> Asa
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Bé Tr?n Van
> *Sent:* Wednesday, May 09, 2012 8:40 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$
!
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Bé Tr?n Van
Sent: Wednesday, May 09, 2012 8:40 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Fwd: Need help on data
2012/5/9 Lokesh Loki
Hai Anil,
Thanks for resolving
2012/5/9 Lokesh Loki
> Hai Anil,
>
> Thanks for resolving the query and thanks for advising me about the user
> form.
>
> Once again thank a lot experts.
>
> Regards
> Lokesh.M
>
> On Wed, May 9, 2012 at 2:42 PM, Anil Gawli wrote:
>
>> Attached is the workbook and go to Calculation worksheet.
>>
Hai Anil,
Thanks for resolving the query and thanks for advising me about the user
form.
Once again thank a lot experts.
Regards
Lokesh.M
On Wed, May 9, 2012 at 2:42 PM, Anil Gawli wrote:
> Attached is the workbook and go to Calculation worksheet.
>
>
>
>
>
>
> On Wed, May 9, 2012 at 6:01 AM,
Hi Lokesh
I do not think you will get a reply from this group to to your question as
it is. What you are asking for is more in the nature of application design
and that is not a quick and simple answer to a question. This group exists
to help people who are having problems with VBA in Excel. Whi
AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Fwd: Need help on data
Hi Experts,
Still i am not receiving any results in the group, could you please help on
us for the below query.
I need a beautiful form, when i am selecting the name it contains all the
data which is already
*From:* excel-macros@googlegroups.com [mailto:
>>> excel-macros@googlegroups.com] *On Behalf Of *rekha siri
>>> *Sent:* Jan/Sun/2012 04:47
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* Re: $$Excel-Macros$$ Fwd: Need help in building pivot usi
>> ** **
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *rekha siri
>> *Sent:* Jan/Sun/2012 04:47
>> *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ Fwd: Need help in building pivot
marySheet..
>
> Rajan.
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *rekha siri
> *Sent:* Jan/Sun/2012 04:47
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Fwd: Need help in building piv
Hi rekha.
I clearly mention that don't delete the summarySheet..
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of rekha siri
Sent: Jan/Sun/2012 04:47
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Fwd: Need help in building
te SUmmarySheet
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *rekha siri
> *Sent:* Jan/Sat/2012 08:51
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Fwd: Need help in building pivot using vba
&
r Each c In sh.Range(sh.[S3], sh.[S65536].End(xlUp)).Offset(, 1)
>
> c.Value = Application.VLookup(c.Offset(, -1) * 1, rg, 3, 0)
>
> Next c
>
> End With
>
> ActiveWorkbook.Close False
>
> Application.Calculation = inCalculationMode
>
> Application.ScreenUpd
-macros@googlegroups.com] De
la part de Prathima R
Envoyé : lundi 4 avril 2011 13:16
À : excel-macros@googlegroups.com; ayush jain; ashish koul
Objet : $$Excel-Macros$$ Fwd: Need Help
Hi experts,
I am not good at excel vba, i just tried recording macro b
thanx ashish will try this code
i also wanted formula to extract only the 10 digit mobile numbers from the
data list
+ 022-2 Ex-6432341 ~+ 9870188646 + 022-2 Ex-6487723 + 022-2
Ex-6658518 ~+ 9821916656 + 022-2 Ex-6795123 + 0251- Ex-2311543 ~+
9869478989 ~+ 2311543 +91 (022) 99
sorry ashish,
the file is not working when i click on update it opens a pop up says read
only, notify & cancel...
Regards,
On Tue, Jan 18, 2011 at 8:56 PM, ashish koul wrote:
> check the attachment
>
> On Tue, Jan 18, 2011 at 12:20 PM, lucky singh wrote:
>
>>
>> Hello,
>>
>> Guys Need you
check the attachment
On Tue, Jan 18, 2011 at 12:20 PM, lucky singh wrote:
>
> Hello,
>
> Guys Need your help urgently
>
> please
>
> Regrads
>
> -- Forwarded message --
> From: lucky singh
> Date: Tue, Jan 18, 2011 at 10:51 AM
> Subject: need help
> To: excel-macros@googleg
Hello,
Guys Need your help urgently
please
Regrads
-- Forwarded message --
From: lucky singh
Date: Tue, Jan 18, 2011 at 10:51 AM
Subject: need help
To: excel-macros@googlegroups.com
Hi Guys need your help,
I have 25 agenst overall & I have to record & listen to 12 calls
Thanks alot ashish its excellent..
On Sat, Jan 8, 2011 at 3:10 PM, ashish koul wrote:
> check the attachment see if it helps
>
>
> On Sat, Jan 8, 2011 at 11:12 AM, Rajasekhar Praharaju <
> rajasekhar.prahar...@gmail.com> wrote:
>
>> Please find the attached sheet i could able to b
check the attachment see if it helps
On Sat, Jan 8, 2011 at 11:12 AM, Rajasekhar Praharaju <
rajasekhar.prahar...@gmail.com> wrote:
> Please find the attached sheet i could able to build formula for single
> line item
>
> But i want if the criteria is having mulitple line items the results should
Please find the attached sheet i could able to build formula for single line
item
But i want if the criteria is having mulitple line items the results should
display as
Date description, Date description, Date description.
Please help me in this concern,
Thanks,
Raj
On Sat, Jan 8, 2011 at 10:4
Hi ,
Please help me in this concern,
In this sheet i am trying to place vlookup for multiple fields yaar
it should through the description and date in AG column basing on list of
activities.
but i should get this in horizontal basis..
can anyone plz help me in this concern.
for example
if on
Hi ,
In this sheet i am trying to place vlookup for multiple fields yaar
it should through the description and date in AG column basing on list of
activities.
but i should get this in horizontal basis..
can anyone plz help me in this concern.
for example
if one activity is performed twice whi
Dear all,
I need your help in formula, i need correct formula to get daily total
salary and ot amount..
please help me.. i have send the attachment too..
Thank®ards,
Ram,
--~--~-~--~~~---~--~~
-
-- Forwarded message --
From: vidyut more
Date: Sat, Jun 27, 2009 at 10:44 AM
Subject: $$Excel-Macros$$ Fwd: Need help regarding formula
To: excel-macros@googlegroups.com
-- Forwarded message --
From: vidyut more
Date: Wed, Jun 24, 2009 at 2:47 PM
Subject: Need
-- Forwarded message --
From: vidyut more
Date: Wed, Jun 24, 2009 at 2:47 PM
Subject: Need help regarding formula
To: mac...@googlegroups.com, karthikb...@rediffmail.com, vidyut
Hi
i need formula in worksheet i have attached. that could automaticly
serach last Pc No of Particula
28 matches
Mail list logo