Re: $$Excel-Macros$$ Screen Updating

2013-08-14 Thread respuzy
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:

Re: $$Excel-Macros$$ Auto Sum in Macro Recording

2013-08-05 Thread respuzy
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:

Re: $$Excel-Macros$$ Auto Sum in Macro Recording

2013-08-03 Thread respuzy
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:

Re: $$Excel-Macros$$ 9e+307

2013-07-25 Thread respuzy
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

Re: $$Excel-Macros$$ Index Match Not working in VBA

2013-07-20 Thread respuzy
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:

Re: $$Excel-Macros$$ Amazing Excel Charts

2013-07-13 Thread respuzy
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;

Re: $$Excel-Macros$$ How to get the Month end date from a list of dates

2013-06-22 Thread respuzy
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:

Re: $$Excel-Macros$$ Extract Unique Values with VBA

2013-06-19 Thread respuzy
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

Re: $$Excel-Macros$$ Re: Vba Code to extract Data from one sheet to another

2013-03-29 Thread respuzy
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:

Re: $$Excel-Macros$$ Re: Macro to be added to new sheets when createdfrom a template *

2013-03-21 Thread respuzy
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:

$$Excel-Macros$$ Unhide some sheets starting from a specific sheet number

2013-02-03 Thread respuzy
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

Re: $$Excel-Macros$$ Unhide some sheets starting from a specific sheet number

2013-02-03 Thread respuzy
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:

Re: $$Excel-Macros$$ Re: Unhide some sheets starting from a specificsheet number *

2013-02-03 Thread respuzy
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:

Re: $$Excel-Macros$$ Prince Kumar - Most Helpful Member Jan'13

2013-02-01 Thread respuzy
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:

Re: $$Excel-Macros$$ Re: VBA Code -Slide Show

2013-01-23 Thread respuzy
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

$$Excel-Macros$$ Slow processing of Data

2013-01-03 Thread respuzy
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 ♍Ɣ

Re: $$Excel-Macros$$ Slow processing of Data

2013-01-03 Thread respuzy
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:

Re: $$Excel-Macros$$ Slow processing of Data *

2013-01-03 Thread respuzy
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

Re: $$Excel-Macros$$ Slow processing of Data * *

2013-01-03 Thread respuzy
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:

Re: $$Excel-Macros$$ Happy b'day Noorain Ansari

2013-01-01 Thread respuzy
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:

Re: $$Excel-Macros$$ Data collection - Problem *

2012-12-27 Thread respuzy
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:

Re: $$Excel-Macros$$ Re: Merry Christmas Happy New Year *

2012-12-26 Thread respuzy
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:

Re: $$Excel-Macros$$ Re: Merry Christmas Happy New Year *

2012-12-24 Thread respuzy
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

Re: $$Excel-Macros$$ Re: Vba code to Check authorised users * * *

2012-12-21 Thread respuzy
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

Re: $$Excel-Macros$$ Re: Vba code to Check authorised users *

2012-12-20 Thread respuzy
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

Re: $$Excel-Macros$$ Re: Dynamic calendar quiz : There is a prize for the winner. *

2012-12-13 Thread respuzy
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:

Re: $$Excel-Macros$$ Re: Dynamic calendar quiz : There is a prize for the winner. *

2012-12-13 Thread respuzy
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:

Re: $$Excel-Macros$$ Re: Add a new sheet and named based on last item ina row *

2012-12-06 Thread respuzy
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:

Re: $$Excel-Macros$$ Add a new sheet and named based on last item in a row *

2012-12-06 Thread respuzy
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 =

Re: $$Excel-Macros$$ Add a new sheet and named based on last item in a row *

2012-12-06 Thread respuzy
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:

Re: $$Excel-Macros$$ Add a new sheet and named based on last item in a row *

2012-12-06 Thread respuzy
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

Re: $$Excel-Macros$$ Paul Schreiner - Most Helpful Member November'12 *

2012-12-03 Thread respuzy
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:

Fw: $$Excel-Macros$$ Dynamic Fixed Asset Depreciation Schedule *

2012-12-01 Thread respuzy
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

Re: $$Excel-Macros$$ Masking Password in input box * * *

2012-10-26 Thread respuzy
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

Re: $$Excel-Macros$$ All time high Price *

2012-09-20 Thread respuzy
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:

Re: $$Excel-Macros$$ All time high Price *

2012-09-20 Thread respuzy
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:

Re: $$Excel-Macros$$ UPGRADE-STOCK MARKET INFORMATION DASHBOARD

2012-08-28 Thread respuzy
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

Re: $$Excel-Macros$$ UPGRADE-STOCK MARKET INFORMATION DASHBOARD

2012-08-28 Thread respuzy
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

Re: $$Excel-Macros$$ UPGRADE-STOCK MARKET INFORMATION DASHBOARD

2012-08-25 Thread respuzy
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

Re: $$Excel-Macros$$ BullsEye Chart

2012-08-11 Thread respuzy
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:

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

2012-08-03 Thread respuzy
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:

Re: $$Excel-Macros$$ Re: ♍Ɣ President is Dead

2012-07-24 Thread respuzy
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:

Re: $$Excel-Macros$$ Fwd: Visualize Excel Salary Data You could win XBOX 360 + Kinect Bundle [Contest] (chandoo.org)

2012-06-27 Thread respuzy
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:

Re: $$Excel-Macros$$ Re: MY NEW EXCEL DASHBOARD PROJECTS

2012-06-26 Thread respuzy
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

Re: $$Excel-Macros$$ Introduce Yourself !!

2012-06-08 Thread respuzy
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

Re: $$Excel-Macros$$ Lookup and return 2nd occurrance

2012-06-03 Thread respuzy
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:

Re: $$Excel-Macros$$ Lookup and return 2nd occurrance

2012-06-03 Thread respuzy
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

Re: $$Excel-Macros$$ Rajan Verma - Most helpful Member(May'12)

2012-06-03 Thread respuzy
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

$$Excel-Macros$$ Lookup and return 2nd occurrance

2012-05-31 Thread respuzy
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.

Re: $$Excel-Macros$$ Lookup and return 2nd occurrance

2012-05-31 Thread respuzy
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:

Re: $$Excel-Macros$$ Urgent Client Position ::: Java Developer - Work Location: Palo Alto, CA

2012-05-24 Thread respuzy
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:

Re: $$Excel-Macros$$ Link Check Box many times

2012-05-17 Thread respuzy
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:

Re: $$Excel-Macros$$ Financial Analysis Dashboard

2012-05-15 Thread respuzy
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:

Re: $$Excel-Macros$$ Date Problem

2012-05-09 Thread respuzy
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:

Re: $$Excel-Macros$$ Date Problem

2012-05-09 Thread respuzy
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:

Re: $$Excel-Macros$$ Date Problem

2012-05-08 Thread respuzy
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:

Re: $$Excel-Macros$$ Date Problem

2012-05-08 Thread respuzy
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:

Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Apr'2012

2012-05-02 Thread respuzy
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:

Re: $$Excel-Macros$$ Re: Creation of dashboard

2012-04-17 Thread respuzy
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

Re: $$Excel-Macros$$ Re: Creation of dashboard

2012-04-17 Thread respuzy
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

Re: $$Excel-Macros$$ Most helpful Member - March 12- Don Guillett

2012-04-15 Thread respuzy
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

Re: $$Excel-Macros$$ Amount of words in Rectangular Shape box problem

2012-04-05 Thread respuzy
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

Re: $$Excel-Macros$$ Re: Delivery Status Notification (Failure)

2012-03-31 Thread respuzy
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;

Re: $$Excel-Macros$$ Excel formula help needed

2012-03-24 Thread respuzy
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:

Re: $$Excel-Macros$$ Excel formula help needed

2012-03-24 Thread respuzy
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

Re: $$Excel-Macros$$ Excel formula help needed

2012-03-23 Thread respuzy
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:

Re: $$Excel-Macros$$ DASHBOARD FOR STOCK MARKET REVIEW

2012-02-09 Thread respuzy
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:

Re: $$Excel-Macros$$ TEXT FUNCTION PROBLEM

2012-02-06 Thread respuzy
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:

Re: $$Excel-Macros$$ TEXT FUNCTION PROBLEM

2012-02-06 Thread respuzy
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:

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

2012-02-01 Thread respuzy
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