Ok. Tx
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: vba v...@vabs.in
Sender: excel-macros@googlegroups.com
Date: Wed, 14 Aug 2013 10:32:51
To: excel-macros@googlegroups.comexcel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re:
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 v...@vabs.in
Sender: excel-macros@googlegroups.com
Date:
Hi bosses
Any assistance with this? Cheers
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Hilary Lomotey resp...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Fri, 2 Aug 2013 12:40:20
To: excel-macrosEXCEL-MACROS@googlegroups.com
Reply-To:
Its the biggest number excel knows. Assuming you have a list of numbers in
column A and you always want excel to deliver the last number in the row to you
anytime you update the row. You can use lookup(9e+307,a:a). Your way of telling
excel look for the last number in column A or any range
Hello Experts
Pls can someone assist on ♍Ɣ request below. If ♍Ɣ requirement explanation Ȋ̝̊̅§
not properly understood pls let me know. Cheers
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Hilary Lomotey resp...@gmail.com
Sender:
Great collection. Thanks Ashish
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: ashish koul koul.ash...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Fri, 12 Jul 2013 21:08:44
To: excel-macrosexcel-macros@googlegroups.com;
I love your solution. Really cool formula. Bravo and thanks a lot. Its perfect.
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: De Premor d...@premor.net
Sender: excel-macros@googlegroups.com
Date: Sat, 22 Jun 2013 08:38:40
To:
Excellent. Its perfect.
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: VBA VABZ v...@vabs.in
Date: Wed, 19 Jun 2013 23:42:22
To: excel-macros@googlegroups.comexcel-macros@googlegroups.com
Cc: resp...@gmail.com
Subject: Re: $$Excel-Macros$$ Extract Unique
Perfect. Lalit. Thanks so muche
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Lalit Mohan Pandey mohan.pande...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Fri, 29 Mar 2013 02:30:36
To: excel-macros@googlegroups.com
Reply-To:
Thanks Boss very helpful
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Shekhar shekhar.rai...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Wed, 20 Mar 2013 05:29:03
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Cc:
Hello experts
Assuimg I have 10 sheets in a workbook. And I want to unhide the 7th sheet up
to the last sheet Kindly help with vba code to do that. So technically every
sheet from the first sheet Ȋ̝̊̅§ hidden. Any sheet that Ȋ̝̊̅§ after the 10th
sheet shd bE unhidden. Thnks
Sent from my
Hello Dave
I get a compile error type mismatch on sh
E
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: David Grugeon da...@grugeon.com.au
Sender: excel-macros@googlegroups.com
Date: Sun, 3 Feb 2013 22:24:27
To:
Thanks prince its working nicely except that for the purpoze of what I want to
do I don't want an input box but want to hard code the number instead in the
code. Thanks
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Prince prince141...@gmail.com
Sender:
Bravo again ♍Ɣ friend well done and thanks for your massive and valuable
support.
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Ayush Jain jainayus...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Sat, 2 Feb 2013 11:49:07
To:
Say sheet 1 has several picture placed in there so I want a code to preview
the slide show in the excel file. Thnks
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Prince prince141...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Wed, 23 Jan 2013
Hello Big Bosses
I have a data am preparing which currently has no VBA actions only formulas.
But anytime I click enter on any action or check a button calculation
processing starts from 58% to 100% before it completes the action. If I get to
the formula tab and set calculation to manual ♍Ɣ
Thanks Anil but if I paste the formula as values it won't solve ♍Ɣ problem as
the data will be static.
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: अनिल नारायण गवली gawlianil8...@gmail.com
Date: Thu, 3 Jan 2013 15:03:04
To:
This Ȋ̝̊̅§ very valuable info unfortunately this forum limits the size of data
I can send as ♍Ɣ file Ȋ̝̊̅§ about 6mg. So I can't send the file but can you let
me have the VBA code to do this or any option to send the file to you. Thanks
Sent from my BlackBerry® smartphone from Airtel Ghana
Thanks will do
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Prajakt Pande prajakt.pa...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Thu, 3 Jan 2013 14:49:38
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re:
Happy Birthday big bro
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: koul.ash...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Tue, 1 Jan 2013 18:43:59
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject:
Hi your requirement Ȋ̝̊̅§ not too clear. What do you want to copy and where do
you want it pasted. Can you explain a bit more.
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Bhaity Koneng bhaity.kon...@gmail.com
Sender: excel-macros@googlegroups.com
Date:
FORUM RULES
2) Don't post a question in the thread of another member
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: rohit tharwani tharwani.ro...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Wed, 26 Dec 2012 15:52:18
To:
Merry Christmas
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Lalit Mohan Pandey mohan.pande...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Mon, 24 Dec 2012 22:00:48
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Hi Lalit
If I don't want only the name of the user to appear once the file opens can you
make an adjustment? Ie when the file Ȋ̝̊̅§ opened the user name and time
appears on the file name. The time Ȋ̝̊̅§ cool but then every person can see the
user name and could log in with that user name so I
Hi Lalit looks Li̶̲̥̅̊K̶̲̥̅̊ε̲̣̣̣̥ it but I don't know the user name to type so
I haven't been able to access this. Kindly provide the user name. But it looks
Li̶̲̥̅̊K̶̲̥̅̊ε̲̣̣̣̥ exactly what I want.
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Lalit
Can we see all the calenders of participants?
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Paul Schreiner schreiner_p...@att.net
Sender: excel-macros@googlegroups.com
Date: Thu, 13 Dec 2012 11:11:20
To: excel-macros@googlegroups.com
Reply-To:
Congratulations to the winners
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Paul Schreiner schreiner_p...@att.net
Sender: excel-macros@googlegroups.com
Date: Thu, 13 Dec 2012 11:11:20
To: excel-macros@googlegroups.com
Reply-To:
Thanks prince but I get a debug error on the
Strtname =sheets(1).range(a1 rows.count).end(xlup)
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Prince prince141...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Thu, 6 Dec 2012 03:51:53
To:
Hi experts
I have been able to amend the code to pick any new sheet name that Ȋ̝̊̅§
created.
What I kindly request Ȋ̝̊̅§ the format from the first sheet to the new sheet.
See ♍Ɣ new code below.
Sub copydata()
Dim ws1 as worksheet
Dim ws2 as worksheet
Dim strtname as string
strName =
Used Macro recording to achieved ♍Ɣ purpose thanks
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: resp...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Thu, 6 Dec 2012 13:16:02
To: excel-macros@googlegroups.com
Reply-To:
Yes that Ȋ̝̊̅§ what I did.
The effect of that being 3 different macros
One to create a new sheet and name the sheet by the name item
Second to copy data from a particular sheet and paste it in the sheet created
above
The last one Ȋ̝̊̅§ to copy the format in that particular sheet and paste it
I couldn't agree more. Thumbs up Paul. Great to be associated with you.
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Ayush Jain jainayus...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Mon, 3 Dec 2012 23:58:06
To:
Hello Gurus
i am trying to develop a very dynamic Fixed Asset depreciation schedule but
facing a slight formula or logic challenge and as usual seeking your expert
advice. Basically what this current schedule does is assuming you want to
depreciate your asset for say 5 years, starting from 2013
Hi Paul
Thnks noted
Pls can Ʊ exactly suggest what I have to do.
When I adjust the code to
Only frd_show it pops up correctly. However I am left with connecting the
correct password to the userform form ie when I type password into the
textbox1.
Sent from my BlackBerry® smartphone from
Thanks Don. Really appreciate. Pls can you assist with an excel formula as well?
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: dguillett1 dguille...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Thu, 20 Sep 2012 14:13:37
To:
Its because of what I am applying it to. Formula makes it much more dynamic
rather than macros.
Hi kumar I no I should use the max function but how to apply it to the scenario
Ȋ̝̊̅§ the problem. Thanks
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From:
Hi KSAGAR
If one doesn't have an understanding of the domain area you can't design a
dashboard for it. I don't hv much operating knowledge of what you are
describing.
Thnks
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: SAGAR KASANGOTTUWAR
You asked of DB for share accounting and calculations for income tax. That is
the domain area am referrin to
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: SAGAR KASANGOTTUWAR sagarkasangottu...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Tue, 28
Hi Amar
I built the dashboard in 2007 and 2010 environment. Am not sure why you can't
view in 2003. Maybe Most of the functions I used are not in 2003 so Ʊ may
probably get an error.
Ʊ can upgrade your 2003 to 2007 or 10. 2010 also has 2003 environment so if Ʊ
prefer that you can stick to
Thanks Raj
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Rajan_Verma rajanverma1...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Sat, 11 Aug 2012 16:49:30
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject:
Congrats Boss. Keep up the momentum
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Ayush Jain jainayus...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Fri, 3 Aug 2012 23:10:25
To: excel-macrosexcel-macros@googlegroups.com
Reply-To:
Thanks man.
He was elected in 2009 and was going to run for the 2nd term in Dec this year
The vice president has just been sworn in as President
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: bpascal123 bpascal...@gmail.com
Sender:
Nice I will join the contest
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: yogananda muthaiah yogananda.mutha...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Wed, 27 Jun 2012 22:17:47
To: excel-macrosexcel-macros@googlegroups.com
Reply-To:
Hi Core
Kindly read ♍Ɣ email you would realize I was very specific in providing the
password to the file.
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: CoRe neculae.vale...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Tue, 26 Jun 2012 00:42:36
Hilary from Ghana. A stockbroker. Interest is excel and football.
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Ayush Jain jainayus...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Fri, 8 Jun 2012 12:21:59
To: excel-macros@googlegroups.com
Thanks Raj. Will try this as well
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Rajan_Verma rajanverma1...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Sun, 3 Jun 2012 12:33:08
To: excel-macros@googlegroups.com
Reply-To:
Thanks for the explanation. What I like abt this formula is it actually picks
not only the 2nd occurance but the last occurance which I think might be useful
going forward. Thanks again
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Asa Rossoff
Congratulation Raj. Proud of you. Lunch for you tommorrow.
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Ayush Jain jainayus...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Sun, 3 Jun 2012 23:12:31
To: excel-macrosexcel-macros@googlegroups.com
Hello Excel Masters
if I have a list if names like below in column A and say I have corresponding
different figures in column B.
Hilary
Rajan
Maries
Noorain
Hilary
Rajan
Don
Kris
Asa
And so on and I want to return for instance the second occurance of hilary with
its corresponding figure.
Thanks guys I have figured it out with index and match and countif. Thanks
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: resp...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Thu, 31 May 2012 19:42:32
To: excel-macros@googlegroups.com
Reply-To:
Why do you keep sending this ad over and over again.
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: sai girish saigiris...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Thu, 24 May 2012 22:42:19
Reply-To: excel-macros@googlegroups.com
Subject:
Thanks Asa
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Asa Rossoff a...@lovetour.info
Sender: excel-macros@googlegroups.com
Date: Wed, 16 May 2012 16:08:09
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: RE:
Not at all. Pls feel free to share
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Ashish Pradhan ashlyprad...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Tue, 15 May 2012 13:58:38
To: excel-macros@googlegroups.com
Reply-To:
Alright now makes meanin. Thanks Sam
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Sam Mathai Chacko samde...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Tue, 8 May 2012 13:00:14
To: excel-macros@googlegroups.com
Reply-To:
Thanks Ross
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Asa Rossoff a...@lovetour.info
Sender: excel-macros@googlegroups.com
Date: Tue, 8 May 2012 16:33:57
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: RE:
Thanks Sam for the quick response.
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Sam Mathai Chacko samde...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Tue, 8 May 2012 11:20:37
To: excel-macros@googlegroups.com
Reply-To:
Thanks for this as well Noorain. But can you explain why excel was returning
Jan when I tried ♍Ɣ earlier formula? Just for ♍Ɣ information. Thnks
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: NOORAIN ANSARI noorain.ans...@gmail.com
Sender:
Congrats Raj. Proud of you
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Ayush Jain jainayus...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Wed, 2 May 2012 21:30:32
To: excel-macrosexcel-macros@googlegroups.com
Reply-To:
Hi Deba
Asa is spot on with Chandoos site. Gives very basic info wrt Dashboard. What I
would like to also say is that with Dashboard creation, you have a lot of
lookup situations. Index and Match function is you best Friend for this,Choose
function will be your sister.Rows and Columns will be
Hi Deba
Am currently on .BB () only so you have to go thru this process yourself.
If you want the % of total billing against bal of billing to achieve then
1. In the Dashboard sheet divide cell F8 by cell G8. Give it a label and then
next to it type a 100% and label that also
2. Copy the
Hurray Don. 76 ?wow
Congrats and a very Happy birthday.
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Mohammed Muneer mmun...@ccc.com.qa
Sender: excel-macros@googlegroups.com
Date: Sun, 15 Apr 2012 16:13:27
To: excel-macros@googlegroups.com
Thanks really appreciate it.
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Asa Rossoff a...@lovetour.info
Sender: excel-macros@googlegroups.com
Date: Thu, 5 Apr 2012 11:22:28
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Genius and Thanks Maries exactly what I wanted
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Maries talk2mar...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Sat, 31 Mar 2012 09:13:04
To: hilary lomoteyresp...@gmail.com;
Thanks Kris for the quick reply
A little bug in the formula
If you include the named range matchcol in the formula. The figures don't
update when you select another year.
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Kris krishnak...@gmail.com
Date:
Hi Kris
Kindly select start year as 2012 or 2013. You will realize that these two yrs
do not hv any data but if you select them its populates the data from 2006
onward instead of blank.
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Kris
Hi Kris
Pls why is it that when you select ALL YEAR from cell H4 it seem to give a
error?
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Kris krishnak...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Fri, 23 Mar 2012 08:52:30
To:
Its just historical stock market information for the Ghana stock exchange and
major mkt indicators. But its the idea behind in tht u can picture any report
you want to generate and design it along side
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From:
Thanks boss
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: dguillett1 dguille...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Mon, 6 Feb 2012 09:50:15
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re:
Thanks Sam.you guys are genius. VEry grateful
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Sam Mathai Chacko samde...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Tue, 7 Feb 2012 00:40:37
To: excel-macros@googlegroups.com
Reply-To:
Congrats NOORAIN ANSARI
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: xlstime xlst...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Wed, 1 Feb 2012 22:17:19
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Cc: NOORAIN
70 matches
Mail list logo