On Mon, 7/17/17, Saleem Ansari wrote:
Subject: Re: $$Excel-Macros$$ Urgent Help required
To: excel-macros@googlegroups.com
Date: Monday, July 17, 2017, 9:29 AM
Question not clear
On Mon, Jul 17, 2017 at
9:13 AM, Rakesh kumar
wrote:
Hi
see this attachment. hope it makes you understand.
On Mon, Jul 17, 2017 at 11:59 AM, Saleem Ansari
wrote:
> Question not clear
>
> On Mon, Jul 17, 2017 at 9:13 AM, Rakesh kumar
> wrote:
>
>> Hi Friends,
>>
>> I need urgent help, If any one can help me.
>>
>> actually I have got one assignment,
Question not clear
On Mon, Jul 17, 2017 at 9:13 AM, Rakesh kumar
wrote:
> Hi Friends,
>
> I need urgent help, If any one can help me.
>
> actually I have got one assignment, I need to solve it, but I'm completely
> stuck into this.
>
> Please see the attachment and help.
>
>
> --
> Thanks £ Rega
Can you share the file?There's really no other way I can even GUESS what might
be wrong.
Is the macro looking in the correct cell for a path?Is there a value in the
cell?Is the path spelled correctly? using the correct syntax?does the path
exist?
Since it works for ME, there's really no way to g
Dear Paul,
thanks for the reply.
I am also working on the option number 3, which you have suggested.
where is you see, I am assigning a value of path to a veriable "P" and the
using "ChDir = P"
where value of P is taking from a excel cell.
Kindly suggest what may be going wrong in it.
On Thu,
In Macro1, you specify the full pathname:Workbooks.Open Filename:= _
"D:\Phillipins\Automation\Raw Data\CUSTOMIZED REPORT.xlsx"
in the others, you are not defining the path.In the first you ARE using:ChDir
"D:\Phillipins\Automation\Raw Data"but don't need it in Macro1
since you're not incl
First of all:I enjoy helping.Normally, I sort my list of emails (sometimes a
hundred or more)and immediately delete the emails with subjects like:"Please
Help", "Urgent" and "Help Required".Because ALL the people that post to these
sites are doing so because they need assistance, and to THEM, it
Hi Rakesh
Did you checked this?
+
*I did not do this for you. God is here working through me for you.*
On Tue, Dec 16, 2014 at 10:32 PM, Vaibhav Joshi wrote:
>
> Mr. Aptech...
>
>
> Check this..
>
> Goto Input sheet, Pres Alt + F8 to run macro..
>
> Cheers!!
>
> +
> *I did not do this f
Mr. Aptech...
Check this..
Goto Input sheet, Pres Alt + F8 to run macro..
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Tue, Dec 16, 2014 at 5:54 PM, Rakesh kumar
wrote:
>
> I want all, whatever the is available on sheets.
>
> On Tue, Dec 16, 2014 at
I want all, whatever the is available on sheets.
On Tue, Dec 16, 2014 at 5:47 PM, Vaibhav Joshi wrote:
>
> ok, do you want both or unique one?
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Tue, Dec 16, 2014 at 5:43 PM, Rakesh kumar
> wrote:
>>
>> it was
ok, do you want both or unique one?
+
*I did not do this for you. God is here working through me for you.*
On Tue, Dec 16, 2014 at 5:43 PM, Rakesh kumar
wrote:
>
> it was just sample output.
>
> On Tue, Dec 16, 2014 at 5:19 PM, Vaibhav Joshi wrote:
>>
>> there is 2 raw of data but your outp
it was just sample output.
On Tue, Dec 16, 2014 at 5:19 PM, Vaibhav Joshi wrote:
>
> there is 2 raw of data but your output doesn't contain 68 & what about
> repeated number 65 to 67?
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Tue, Dec 16, 2014 at 5:03
there is 2 raw of data but your output doesn't contain 68 & what about
repeated number 65 to 67?
+
*I did not do this for you. God is here working through me for you.*
On Tue, Dec 16, 2014 at 5:03 PM, Rakesh kumar
wrote:
>
> HI frinds,
> i want split cells value in diffrent row using macro
column no action work.
>>>>
>>>> thanx
>>>>
>>>> On 30 September 2014 23:37, Vaibhav Joshi wrote:
>>>>>
>>>>> Sudhir
>>>>>
>>>>> Did you checked this
>>>>>
>>>>&
and
>>> secondly if there is need to increase column no action work.
>>>
>>> thanx
>>>
>>> On 30 September 2014 23:37, Vaibhav Joshi wrote:
>>>
>>>> Sudhir
>>>>
>>>> Did you checked this
>>>> ---
id you checked this
>>> -- Forwarded message --
>>> From: "Vaibhav Joshi"
>>> Date: Sep 27, 2014 2:38 PM
>>> Subject: Re: $$Excel-Macros$$ URGENT HELP( CONDITION SEARCH OF UNIQUE
>>> TEXT)
>>> To: "excel-macros@goo
is need to increase column no action work.
>
> thanx
>
> On 30 September 2014 23:37, Vaibhav Joshi wrote:
>
>> Sudhir
>>
>> Did you checked this
>> -- Forwarded message --
>> From: "Vaibhav Joshi"
>> Date: Sep 27, 2014 2:
ibhav Joshi"
> Date: Sep 27, 2014 2:38 PM
> Subject: Re: $$Excel-Macros$$ URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT)
> To: "excel-macros@googlegroups.com"
> Cc:
>
> Hi
>
> Check this.. click blue button to run macro!
>
> Cheers!!
>
> +
> *
Sudhir
Did you checked this
-- Forwarded message --
From: "Vaibhav Joshi"
Date: Sep 27, 2014 2:38 PM
Subject: Re: $$Excel-Macros$$ URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT)
To: "excel-macros@googlegroups.com"
Cc:
Hi
Check this.. click blue button t
Dear All,
Kindly help.
On 27 September 2014 14:38, Vaibhav Joshi wrote:
> Hi
>
> Check this.. click blue button to run macro!
>
> Cheers!!
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Thu, Sep 25, 2014 at 10:44 PM, SUDHIR VERMA
> wrote:
>
>> Dear Expe
Does that mean you would like to have color from 09th October till 23rd
Oct. in this case.
On Sun, Sep 28, 2014 at 12:20 PM, Rakesh kumar
wrote:
> hi friends,
>
> i need urgent help of yours
>
> in attached sheets column DOC has date. in next column 'No. of Days Req'
>
> if we enter 8 oct in
Hi
Check this.. click blue button to run macro!
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Thu, Sep 25, 2014 at 10:44 PM, SUDHIR VERMA wrote:
> Dear Experts,
>
> Kindly resolve my problem.
>
> Explanation in attached workbook.
>
> Thanking You
>
> R
Dear Ganesh,
Thanx for provide formula. It's also great but there is more than 100
column where were conditions found. So it is not possible to entered
formula.
thanking you
On 26 September 2014 09:44, Ganesh N wrote:
> Hi sudhir,
>
> PFA.
>
> Just given if condition.
>
> Regards,
> Ganesh N
Hi sudhir,
PFA.
Just given if condition.
Regards,
Ganesh N
On Thu, Sep 25, 2014 at 10:44 PM, SUDHIR VERMA wrote:
> Dear Experts,
>
> Kindly resolve my problem.
>
> Explanation in attached workbook.
>
> Thanking You
>
> Regards
> Sudhir
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?
can you highlight error cells!!
On Mon, Jul 28, 2014 at 10:43 AM, bhanu prakash wrote:
> Hi Vaibhav,
>
> Had checked your solution, few lvl's are picking up correct & other few
> are lvl picking wrong #'s ..had checked your response..
>
> Regards,
> Bhanu
>
>
>
> On Sat, Jul 26, 2014 at 10:54 A
gt;
>>>
>>>
>>>
>>> *“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*
>>> ---
Hi Vaibhav,
Had checked your solution, few lvl's are picking up correct & other few are
lvl picking wrong #'s ..had checked your response..
Regards,
Bhanu
On Sat, Jul 26, 2014 at 10:54 AM, Vaibhav Joshi wrote:
> did this helped?
>
>
>
> On Fri, Jul 25, 2014 at 6:44 PM, Vaibhav Joshi wrote:
macros@googlegroups.com
> *Sent:* Friday, July 25, 2014 7:45 AM
> *Subject:* Re: $$Excel-Macros$$ URGENT : Help on excel for matching data
>
> Hi Paul,
>
> Thanks for your response.
>
> But here biggest challenge is FBC Value in DATA MATCH sheet ( Column E )
> is not e
did this helped?
On Fri, Jul 25, 2014 at 6:44 PM, Vaibhav Joshi wrote:
> Hi
>
> Pl refer attachment, due to your data formula became complex, you can
> check example next to it for an explanation.
>
> Cheers!!
>
>
> On Fri, Jul 25, 2014 at 3:45 PM, bhanu prakash wrote:
>
>> Team,
>>
>> Any ex
As long as ever you can.” - John Wesley
-
>
> From: bhanu prakash
>To: excel-macros@googlegroups.com
>Sent: Friday, July 25, 2014 7:45 AM
>Subject: Re: $$Excel-Macros$$ URGENT : Help on excel for match
Hi Paul,
Thanks for your response.
But here biggest challenge is FBC Value in DATA MATCH sheet ( Column E ) is
not exact match, we need to find the nearest # in SOURCE sheet & I need
that Lvl details..hope this will give you clear idea on what I am looking
for..
Please help
Regards, Bhanu
On
It looks like you've already got it set up.
You're using column A in the Source sheet to concatenate the Group,month and
location.
you need to add the FBC value to this column, however you'll probably want to
round the FBC number to 2 decimal places:
=E3&B3&D3&Round(F3,2)
in your data match she
Team,
Any experts for help on below mentioned request..please help
Regards, Bhanu
On Fri, Jul 25, 2014 at 11:41 AM, bhanu prakash wrote:
> Hello Team,
>
> Hope everyone doing good.
>
> Had attached the excel sheet for reference
>
> in that Excel you will find 2 tabs - one is "SOURCE" and othe
Hey
You can increase line spacing..
Sub para()
Dim oPara As Paragraph
For Each oPara In ActiveDocument.Paragraphs
If Not (Len(oPara.Range.Text) <> 1 And Not
oPara.Range.ListFormat.ListType = bulletList) Then
With oPara
.SpaceAfter = 0
Hi Davidson,
PFA..!!!
If, its not meet your requirement then elaborate more.
Regards
Ashish
On 18 June 2014 19:25, Davidson Chew wrote:
> Hi everyone, I need some real urgent help with my VBA Macro for Microsoft
> Word.
>
> Here's my current code:
> Dim oPara As Paragraph
> F
attachment missing !
On Sat, Oct 5, 2013 at 11:22 AM, Rakesh kumar wrote:
>
> Dear Friend,
>
> i want to use total no of present or absent list using pivot table.
>
> Please find the attachment.
>
>
> --
> Thanks £ Regards
> Rakesh Kumar
> +91-9650303464
>
>
>
> --
> Are you =EXP(E:RT) or =NOT(E
Dear De Premor & Ravinder Sir,
Thanks for your help and valuable support. Thanks a lot.
Thanks,
Ashish Kumar
On Saturday, September 7, 2013 11:32:20 AM UTC+5:30, De Premor wrote:
>
> The good thing is that your sheet name have a same name with what we are
> looking for also the name of month,
The good thing is that your sheet name have a same name with what we are
looking for also the name of month, so we can process it easily, try
this on B2
=COUNTA(OFFSET(INDIRECT($A2&"!$A1"
),2,MATCH(B$1,INDIRECT($A2&"!$1:$1"),0)-1,2^16))
On 07-09-2013 12:43, Ashish Kumar wrote:
Dear Seniors,
Dear Senior,
All data in single workbook in different sheets and i want to create a
summary in output sheet. Data pattern will be same according to the sheet
which i'hve attached for query reference.
Thanks,
Ashish
On Saturday, September 7, 2013 11:22:03 AM UTC+5:30, Excel Group wrote:
>
> Hi
Hi Ashish,
Please confirm that the all data in a single sheet or in different
different sheets.
On Sat, Sep 7, 2013 at 11:13 AM, Ashish Kumar wrote:
> Dear Seniors,
>
>
> I want total count of Sold Items according to the state or months. I'hve
> tried this through Counta formula but this is h
l find here with sales register
> kindly help me to sort out and also inform how i could make such file like
> also same in the case of
> purchase register
> thanks
> d v nayak
>
> --
> Date: Tue, 23 Jul 2013 17:06:24 +0530
> Subject: Re: $$
Hi nayak..pls share the file..
On Jul 23, 2013 12:02 PM, "devanand nayak" wrote:
> hi
> i have one sheet which consists of data on daily basis for whole year
> e.g. datecustomer name tin no net 12.5% vat 12.5% net 5%
> vat 5% oms tranpsort total
>
> i need this with tinwise t
Hi all experts,
Atlast i found the resolution for this issue. i have checked with the team
who are sending this file in zip format on a daily bases. the root cause of
this problem is while zipping this file they get some error. they simply
ignored it and sending this file. when i check with the fi
Respected Prabhu,
Verify that the other cells linked to it are not hidden.Remove any
formulas or links(hyper links or other links) that the cell contains with
other sheets.Also verify that whether multiple cell which are hidden around
the cell are not selected when you select the cell.If the ce
Pl share your file with group.
And use the appropriate subject for your query.
On Tue, May 28, 2013 at 6:44 PM, Prabhu Pinky wrote:
> Nope I have selected only one cell in only one sheet.
>
> Prabhu R
> On May 28, 2013 3:50 PM, "David Grugeon" wrote:
>
>> Perhaps you have more than one sheet sel
Nope I have selected only one cell in only one sheet.
Prabhu R
On May 28, 2013 3:50 PM, "David Grugeon" wrote:
> Perhaps you have more than one sheet selected.
>
> Regards
> David Grugeon
>
>
>
> On 28 May 2013 14:37, Prabhu Pinky wrote:
>
>> hi experts
>>
>> I have one excel, from that excel I
Perhaps you have more than one sheet selected.
Regards
David Grugeon
On 28 May 2013 14:37, Prabhu Pinky wrote:
> hi experts
>
> I have one excel, from that excel I am unable to copy and paste the data
> to new excel..even a single cell..am getting "this command is cannot be
> processd in mult
http://social.technet.microsoft.com/Forums/en-US/officeitpro/thread/cfbcd96c-bcf1-48dc-940e-5d859f44e217
On Tue, May 28, 2013 at 11:26 AM, Prabhu Pinky wrote:
> Hi..
> Am unable to attach the sheet, since there is violation in our office.
>
> As I said earlier, I have selected only one cell. So
Hi..
Am unable to attach the sheet, since there is violation in our office.
As I said earlier, I have selected only one cell. So there is no matter if
I use filter.
Prabhu R
On May 28, 2013 10:42 AM, "VBA VABZ" wrote:
> Hi
>
> Either source sheet has filter or merged cells. Try clearing out f
Dear Prabhu,
Are u pressing cltr+then selecting the cells and trying to copy the
things.?
if u selecting the cells vertically or horizontally but in straight line
then it should copy by selecting cltr key.
But if u selecting the cells randomly then it will not copy and throws the
message whic
Hi
Either source sheet has filter or merged cells. Try clearing out filter
and perform operation again.
If doesn't work send us sheet.
HTH
On 28 May 2013 10:07, "Prabhu Pinky" wrote:
> hi experts
>
> I have one excel, from that excel I am unable to copy and paste the data
> to new excel..even
May I ask why your request is more urgent and more important than the other
requests.??
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Nagendra Modupalli
Sent: Monday, June 04, 2012 11:30 PM
To: excel-macros@googlegroups.com
Subject:
Dear Nagendra,
Please use it
Sub USINGVLOOKUP()
Dim X As Range
Set X = Sheets(1).Range("$A$1:$D$9")
Range("E15").Value
=Application.Worksheetfunction.VLookup(Sheets(1).Range("B15").Value, X, 4,
False)
End Sub
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.bl
just share your data.
Gawli Anil
On Tue, Jun 5, 2012 at 10:00 AM, Nagendra Modupalli wrote:
> Hi Experts,
>
> I have data with Employee number,based on employee number i need to
> get the date of join.i have many file with DOJ.
>
> What is the VBA vlookup code for looking one file and if not find
Hi,
Function English(ByVal N As Currency) As String
Const Thousand = 1000@
Const Million = Thousand * Thousand
Const Billion = Thousand * Million
Const Trillion = Thousand * Billion
If (N = 0@) Then English = "zero": Exit Function
Dim Buf As String: If (N < 0@
Sometime ActiveX does not work properly with Excel 2007, it's a bug , you
can use Form Control and Shapes instead of them
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Divaker Pandey
Sent: Apr/Thu/2012 03:33
To: excel-macros@googlegroups.com
not return an error if the number
is not found, so we need to verify that it found the correct number.
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Satvik
Sent: Friday, March 02, 2012 5:49 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macro
: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Urgent Help Required...!
u can try this one
=INDEX('E:\Desktop\[NDNC
file.xlsx]Sheet1'!$A$2:$B$11,MATCH(A2,'E:\Desktop\[NDNC
file.xlsx]Sheet1'!$A$2:$A$11,0),2)
On Sat, Mar 3, 2012 at 7:19 AM, Satvik wrote:
> **
>
>> **
>> Thanks for the replay Shaik...
>>
>> Yes I need to check with DNC..
>> Sent from BlackBerry® on Airtel
>> --
>> *From: *Shaik Waheed
>> *Sender: *excel-macros@googlegroups.com
>> *Date: *Fri, 2 Mar 2012 18:11:44
43:19
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Urgent Help Required...!
Hi,
You can use vlookup to find the callable # from DNC sheet. Find the
attached file for ur reference.
On Sat, Mar 3, 2012 at 6:59 AM, Satvik wrote:
> **
> Thanks for the replay Shaik
erry® on Airtel
> --
> *From: *Shaik Waheed
> *Sender: *excel-macros@googlegroups.com
> *Date: *Fri, 2 Mar 2012 18:11:44 +0530
> *To: *
> *ReplyTo: *excel-macros@googlegroups.com
> *Subject: *Re: $$Excel-Macros$$ Urgent Help Required...!
>
> Hi,
>
> Do you want to chek wh
Thanks for the replay Shaik...
Yes I need to check with DNC..
Sent from BlackBerry® on Airtel
-Original Message-
From: Shaik Waheed
Sender: excel-macros@googlegroups.com
Date: Fri, 2 Mar 2012 18:11:44
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Urgent
chk attachments solved
On Fri, Mar 2, 2012 at 6:11 PM, Shaik Waheed wrote:
> Hi,
>
> Do you want to chek whether the master file ph.# are callable or
> non-callable by verying it with NDNC sheet?
>
>
>
> On Sat, Mar 3, 2012 at 4:16 AM, Satvik wrote:
>
>> Hi Every One,
>>
>> Friend I need a b
Hi,
Do you want to chek whether the master file ph.# are callable or
non-callable by verying it with NDNC sheet?
On Sat, Mar 3, 2012 at 4:16 AM, Satvik wrote:
> Hi Every One,
>
> Friend I need a big help from you all, as I work in BPO company as a MIS
> executive but I am not aware about Acce
Try Sumif
Kantilal Badale
On Mon, Feb 27, 2012 at 6:02 PM, Arpita kapoor wrote:
> Hi,
>
> Can anyone please help me with a simple formula for the below data set.
> All I need is to a sum of all the figures (+/-) except for those which are
> =><1/-1
>
>0.47 0.40 0.26 1.05 0.21 2.50 0.0
Hi Arpita,
You can also use..
SUMPRODUCT((A1:A16>0)*(A1:A16))
On Mon, Feb 27, 2012 at 6:02 PM, Arpita kapoor wrote:
> Hi,
>
> Can anyone please help me with a simple formula for the below data set.
> All I need is to a sum of all the figures (+/-) except for those which are
> =><1/-1
>
>0.
Hi,
Try below formula with Ctrl+Shift+Enter.
=SUM(IF(A1:A16>0,A1:A16,0))
Find the attached file.
Regards,
MARIES.
On Mon, Feb 27, 2012 at 4:32 PM, Arpita kapoor wrote:
> =><
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titl
Dear Pravesh,
You can use lookup too
VLOOKUP(I13:I19,D11:E24,2)
From: PRAVESH KUMAR
To: excel-macros@googlegroups.com
Sent: Friday, 3 February 2012 11:06 PM
Subject: $$Excel-Macros$$ Urgent Help
Hi,
please help ASAP.
please find attached sheet.
Than
Hi Noorain,
Thanks a lot of...
On 2/3/12, NOORAIN ANSARI wrote:
> Dear Pravesh,
>
> See attached sheet..
>
> =SUMPRODUCT(($D$5:$D$18=K7)*($F$5:$F$18=2)*($E$5:$E$18))
>
> On Fri, Feb 3, 2012 at 11:30 PM, Sam Mathai Chacko
> wrote:
>
>> This should work
>>
>> =INDEX($D$5:$D$18
OK. Here is another way AFTER sorting the source table
INDEX(E:E,MATCH(I6,D:D))
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Sam Mathai Chacko
Sent: Friday, February 03, 2012 12:00 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Urgent Help
This should work
Dear Pravesh,
See attached sheet..
=SUMPRODUCT(($D$5:$D$18=K7)*($F$5:$F$18=2)*($E$5:$E$18))
On Fri, Feb 3, 2012 at 11:30 PM, Sam Mathai Chacko wrote:
> This should work
>
> =INDEX($D$5:$D$18,SMALL(IF($D$5:$D$18<>OFFSET($D$5:$D$18,1,0),ROW(INDIRECT("1:"&ROWS($D$5:$D$18))),""),COUNTA($I$4:I4)))
>
I second Don. please keep in mind that the volunteers here 'lend' their
time to the forum to help. So it would be best to give that extra bit of
information in a clear and concise manner, so that it is easy for the
volunteers.
Sam
On Fri, Feb 3, 2012 at 11:30 PM, Sam Mathai Chacko wrote:
> T
This should work
=INDEX($D$5:$D$18,SMALL(IF($D$5:$D$18<>OFFSET($D$5:$D$18,1,0),ROW(INDIRECT("1:"&ROWS($D$5:$D$18))),""),COUNTA($I$4:I4)))
Regards,
Sam Mathai Chacko
On Fri, Feb 3, 2012 at 11:06 PM, PRAVESH KUMAR wrote:
> Hi,
>
>
> please help ASAP.
>
> please find attached sheet.
>
>
> Thanks
>
>
It is nice to ask in the body of the email what you want. Always, tell us
what you want and give examples. And, speaking for myself, the word URGENT
only tends to make me NOT want to help, at least for free
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
Fr
Hi Paul,
Can you do a favour for me ?
ping me your mail ID at: excelfox at live.in
Kris
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
It appears that Paul has solved it for you.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: nitin arora
Sent: Wednesday, January 04, 2012 7:52 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Urgent help required
Hi Don,
My apologies for the subject and I promise
---
“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: nitin
Hi
Do you want this procedure Only in AB Column..?
Regards
Rajan
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of nitin arora
Sent: Jan/Wed/2012 12:51
To: excel-macros
Subject: $$Excel-Macros$$ Urgent help required
Hi,
Please find attached excel
Hi Don,
My apologies for the subject and I promise this wont happen in future. As
far as "Me" is concerned I am relatively new to this concept of groups so i
have no Idea where should I go to change it to my name. Any help on this
front would be highly appreciated.
As far as the request is concer
FIRST. To some of us, ME, “urgent help required” is a NO NO. All requests are
urgent.
Now, you will need to explain the logic of what you want. If you want to find
every comma on the sheet, what will you do with numbers, etc? You need to
specify which columns to search and you need to tell us wh
Can you please provide code for that?
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of sunil jagtap
Sent: 14 December 2011 18:05
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Urgent help needed on Slow Excel
gt; Regards,
> Amit Desai
>
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of Kiran Kancherla
> Sent: 14 December 2011 13:57
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance
&
half Of Kiran Kancherla
Sent: 14 December 2011 13:57
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance
Hi Amit,
I have copy the data and pasted the data in a new excel sheet.
It was working fine for me.
Please try.
Regards,
Kiran.
Sent o
.com
Date: Wed, 14 Dec 2011 00:25:49
To:
Reply-To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance
The link did not help
Dear Masters, please help me to improve performance of this sheet.
From: excel-macros@googlegroups.com [mailt
Dear Noorain,
Thanks.
Regards
Jitendra Singh
On Tue, Dec 13, 2011 at 11:01 PM, NOORAIN ANSARI
wrote:
> Dear Jitender,
>
> I would suggest you to go ahead and record macro and then watch and
> relate these codes by your steps, which you had taken and start
> understanding VBA.
Dear Jitender,
I would suggest you to go ahead and record macro and then watch and
relate these codes by your steps, which you had taken and start
understanding VBA. You can also refer to the Group's learning
material and find below excel macro ebook..
http://www.4shared.com/document/
dear all,
how can i learn macro.
please suggest me.
Thanks & Regards
Jitendra Singh
On Tue, Dec 13, 2011 at 10:04 PM, dguillett1 wrote:
> *http://tinyurl.com/7yt37xy*
>
>
>
> https://login.live.com/login.srf?wa=wsignin1.0&rpsnv=11&checkda=1&ct=1323793906&rver=6.0.5276.0&wp=MCLBI&
http://tinyurl.com/7yt37xy
https://login.live.com/login.srf?wa=wsignin1.0&rpsnv=11&checkda=1&ct=1323793906&rver=6.0.5276.0&wp=MCLBI&wlcxt=msdn%24msdn%24msdn&wreply=http%3a%2f%2fmsdn.microsoft.com%2fen-us%2flibrary%2faa730921%2528v%3doffice.12%2529.aspx&lc=1033&id=254354&mkt=en-US
http://tinyu
Did you try my solution??
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Anil Bhange
Sent: Thursday, October 27, 2011 11:49 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Urgent help needed
Hi Noorain,
Thanks for the help, but it is not working at my end due
t;> 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
>> *-
>>
>>
>> --
-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Urgent help needed
Seconding Don and Paul on that. Another point that comes to the table is the
lack of proper Subject Titles that clearly and concisely describes the
problem/objective. I know that this is hinted in the forum rules, but do we not
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Urgent help needed
Dear Anil,
Please try through below code and see attached sheet.
Sub Consodilated_sheet_withsheetname()
Dim i, j, k, s As Long
Dim x, y, z As Long
Application.ScreenUpdating = False
x = Sheet1.Cells(1, Columns.Count
> *“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
> *------
you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: dguillett1
To: excel-macros@googlegroups.com
Sent: Thu, October 27, 2011 9:56:09 AM
Subject: Re: $$Excel-Macros$$ Urgent help needed
Anil, Pl
Anil, Please do NOT use urgent in your request as most who would help may even
put that request last on their list or ignore the request.
Try this code, assuming Master Sheet does NOT exist.
===
Option Explicit
Sub ConsodilateSheetsSAS()
Dim dlr As Long
Dim i As Long
Application.ScreenUpdati
Here's a VBA formula that does the trick
http://www.ozgrid.com/forum/showthread.php?t=144212
Regards,
Sam Mathai Chacko (GL)
On Fri, Oct 14, 2011 at 11:03 AM, Dilip Pandey wrote:
> Hi Prathap,
>
> If this is one time exercise then, write 100 somewhere in and copy
> it. Now select the data
Hi Prathap,
If this is one time exercise then, write 100 somewhere in and copy
it. Now select the data and apply paste special - > Values -> Divide.
If this is kinda template where figures will come and go, then you can
use custom format.
Regards,
DILIPandey
On 10/13/11, Prathap wrote:
> H
.
-Original Message-
From: Prathap
Sender: excel-macros@googlegroups.com
Date: Thu, 13 Oct 2011 23:01:01
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Urgent Help required
Thank you all for your assistance.
However i have a sheet (containing 67 columns &
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: Prathap
To: excel-macros@googlegroups.com
Sent: Thu, October 13, 2011 1:31:01 PM
Subject: Re: $$Excel-Macros$$ Urgent H
Thank you all for your assistance.
However i have a sheet (containing 67 columns & 3980 rows) were i need to
change the entire cell into million. Attached is the sample sheet
Best Regards,
PRATHAP D
M +91 9899-370-328
On 13 October 2011 20:22, Prathap wrote:
> Hi,
>
> Is there a way to conver
1 - 100 of 186 matches
Mail list logo
