Dear Prabhakar,
It could be helpful.
please find solved attachment and confirm is it ok or not?
Regards,
Waseem Saifi
On Tue, Aug 6, 2013 at 10:52 AM, wrote:
> Dear Team,
>
> I have dates in different format and need to make it in one standard date
> format. Please help me to fix this.
>
> R
Dear Team,
I have dates in different format and need to make it in one standard date
format. Please help me to fix this.
Rgds,
Prabhakar
--
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 Facebook page of this forum @
https://ww
I am trying to make a macro that deletes a row in a column if it detects a
specific word or phrase from a set of phrases.
"Friendly's"
"Ruth's Chris Steak House"
"Hooters"
"Ruby Tuesday"
"Chili's Grill & Bar"
etc.
I have searched for HOURS to find an answer and have tried combining code
Can u share a sample file
On Mon, Aug 5, 2013 at 10:50 PM, Geoff wrote:
> Hi,
>
> I have a macro written that will check if a value in column X matches a
> specified value, if it does the row gets copied onto another tab and then
> the macro keeps looping to evaluate all the rows. However, whe
Check this page http://www.mcpher.com/Home/excelquirks/json
See if it helps
Regards
Ashish
On Tue, Aug 6, 2013 at 7:23 AM, De Premor wrote:
> **
> That would be great we have a sample file and what you need to do with it
> (what data you need to be exist on json data)
> --
That would be great we have a sample file and what you need to do with it (what
data you need to be exist on json data)
-Original Message-
From: Mog Godiva-Man
Sender: excel-macros@googlegroups.com
Date: Mon, 5 Aug 2013 18:43:34
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $
Pretty much that's exactly what I need to do. Would it be helpful if I
provided a sample file?
Regards,
Godiva.
On Mon, Aug 5, 2013 at 3:47 PM, De Premor wrote:
> I dont know is that exist, but after reading a while about JSON Format,
> i think we can do some simple translation on Excel Data t
I dont know is that exist, but after reading a while about JSON Format,
i think we can do some simple translation on Excel Data to something
looklike bellow
{
"Sheet1": {
"title": "Your Sheet Name Here",
"Data": {
"Row1": {
"Name": "De Premor",
Ooh Vabs you rock. One more request. Can I have a portion of your brains that
works the VBA solutions. Jus a lil part. Thanks mate. Excellent work
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: vba
Sender: excel-macros@googlegroups.com
Date: Mon, 5 Aug 201
But is there a customize VBA that can write it in to Json format
On Aug 5, 2013 12:20 PM, "yogananda muthaiah"
wrote:
> No you cannot convert vba lang to JSON format.
> Microsoft Development team is already working on it. This is been
> identified and will be ready with Microsoft Office 2015 ver
No you cannot convert vba lang to JSON format.
Microsoft Development team is already working on it. This is been
identified and will be ready with Microsoft Office 2015 version.
On Mon, Aug 5, 2013 at 9:31 PM, Mog Godiva-Man wrote:
> Hi experts,
>
> Does anyone have a VBA script to convert exce
Hi,
I have a macro written that will check if a value in column X matches a
specified value, if it does the row gets copied onto another tab and then
the macro keeps looping to evaluate all the rows. However, when cell A# is
blank, but there's data in the rest of the cells in that row the macr
Hi experts,
Does anyone have a VBA script to convert excel files that can define a
structure to be exported into a json format
--
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 Facebook page of this forum @
https://www.facebook.com
Thank you. That is what I suspected, but my client is certain that this is
not so. This confirms what my thoughts were.
Thanks again,
Olivia
On Sun, Aug 4, 2013 at 5:44 PM, Anoop K Sharma wrote:
> Yes, You can make a chart by using a sample of data but the reading of
> chart is of no use as it w
Try this
Private Sub CommandButton1_Click()
Dim Rng As Range
For Each Rng In Range("C1:C20")
If Rng <> "" Then Rng.Offset(, 2) = IIf(Left(Rng, 1) = "`",
"Tax", "Retail")
Next
End Sub
Pada 05/08/2013 16:26, SAJID MEMON menulis:
Dear I am making a small error in my file, onl
Respected Kathirvelan,
Please check the following link for your solution.
http://chandoo.org/wp/2012/05/07/displaying-text-values-in-pivot-tables-without-vba/
Regards,
Vijaykumar
On Mon, Aug 5, 2013 at 3:11 PM, P.VIJAYKUMAR wrote:
> Respected Kathirvelan,
>
> Pivot table sigma values box sho
I tried to understand your code but couldn't. However, see if the attached
helps.
Thanks,
On Mon, Aug 5, 2013 at 2:56 PM, SAJID MEMON wrote:
> Dear I am making a small error in my file, only one condition is working
> in VBA, Please give me tips to complete it
>
> Awaiting your answer
>
> Rega
Respected Kathirvelan,
Pivot table sigma values box should contain only numerical data and not
text data.you can use a normal table instead and use Vlookup or the INDEX
and MATCH functions to get the desired results.
Regards,
Vijaykumar
On Mon, Aug 5, 2013 at 3:01 PM, P.VIJAYKUMAR wrote:
> Re
Respected Kathirvelan,
What exactly is ur requirement.For example, To sort the data or to get the
approved or not approved status on a particular date etc.if your
reuiqrement is not clear then members will not be able to help you.
Regards,
Vijaykumar
On Mon, Aug 5, 2013 at 2:21 PM, KATHIRVELAN
Dear I am making a small error in my file, only one condition is working in
VBA, Please give me tips to complete it
Awaiting your answer
RegardsSajid Memon
--
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) !
Wow Great VBA sorry for replying late, but this is great. Just a little
adjustment i realized you were dividing it by the sum total of the capital
gains, it should rather be dividend by the market value instead for the %
of equities , however the % of portfolio should be the total of the
equities m
Dear Friends,
Please help me to get this answer.
Thanks,
Kathir
On Mon, Aug 5, 2013 at 11:31 AM, KATHIRVELAN N wrote:
> Dear Ashish,
>
> Thanks for the reply. The names will be unique.
>
> Thanks
>
> On Sun, Aug 4, 2013 at 9:25 PM, ashish koul wrote:
>
>> are the names unique ? or will one pe
Hello All,
I've reviewed all replies. Can we do following things ?
<> After opening excel, Sheet1 only should get open !
<> On sheet1, we can write that "Without Enabling macro facility" this
excel will not work.
<> Can we prepare macro which will keep all "fonts & cells" in white color ?
<> I
23 matches
Mail list logo
