Re: $$Excel-Macros$$ Screen Updating

2013-08-14 Thread respuzy
Ok. Tx Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: vba Sender: excel-macros@googlegroups.com Date: Wed, 14 Aug 2013 10:32:51 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Screen Updating This me

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 Sender: excel-macros@googlegroups.com Date: Mon, 5 Aug 201

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 Sender: excel-macros@googlegroups.com Date: Fri, 2 Aug 2013 12:40:20 To: excel-macros Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$

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

2013-07-24 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 where

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 Sender: excel-macros@googlegroups.com Date: Fri, 19

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 Sender: excel-macros@googlegroups.com Date: Fri, 12 Jul 2013 21:08:44 To: excel-macros; excelvbamacros Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macr

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

2013-06-21 Thread respuzy
Hi VABZ not sure how I can use edate for this Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: VBA VABZ Sender: excel-macros@googlegroups.com Date: Sat, 22 Jun 2013 10:02:28 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: R

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

2013-06-21 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 Sender: excel-macros@googlegroups.com Date: Sat, 22 Jun 2013 08:38:40 To: Reply-To: excel-macros@googlegroups.com Sub

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

2013-06-19 Thread respuzy
Hello VABZ Can you walk me thru the code What Ȋ̝̊̅§ the rationale for displaying the equity and selected equity in M1 and M2 respectively. Also the Destination cell (destcell) line of code and the offset bit and criteria range esp the resize bit more can you pls explain. Am ok with the last

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 Date: Wed, 19 Jun 2013 23:42:22 To: excel-macros@googlegroups.com Cc: Subject: Re: $$Excel-Macros$$ Extract Unique Values with VBA PFA. HTH//Vabs On Wed, Jun 19, 2013 at

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 Sender: excel-macros@googlegroups.com Date: Fri, 29 Mar 2013 02:30:36 To: Reply-To: excel-macros@googlegroups.com Cc: excel-macros Subject: $$Excel-Macros$$

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 Sender: excel-macros@googlegroups.com Date: Wed, 20 Mar 2013 05:29:03 To: Reply-To: excel-macros@googlegroups.com Cc: excel-macros Subject: $$Excel-Macros$$ Re: Macro to be ad

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 Sender: excel-macros@googlegroup

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 Sender: excel-macros@googlegroups.com Date: Sun, 3 Feb 2013 22:24:27 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroup

$$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 BlackBe

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 Sender: excel-macros@googlegroups.com Date: Sat, 2 Feb 2013 11:49:07 To: excel-macros Reply-To: excel-macros@googl

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 Sender: excel-macros@googlegroups.com Date: Wed, 23 Jan 2013 07:32:18 To: Reply-To:

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 Sender: excel-macros@googlegroups.com Date: Thu, 3 Jan 2013 14:49:38 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Slow processing of Data * * This me

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 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: अनिल नारायण गवली Date: Thu, 3 Jan 2013 15:03:04 To: ; Hilary Lomotey Reply-To: gawlianil8...@gmail.com

$$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 ♍Ɣ for

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: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Happy b'day Noorain Ansar

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 Sender: excel-macros@googlegroups.com Date: Thu, 27 Dec 2012 13:18:

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 Sender: excel-macros@googlegroups.com Date: Wed, 26 Dec 2012 15:52:18 To: Reply-To: excel-macros@googlegroups.com Subject:

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 Sender: excel-macros@googlegroups.com Date: Mon, 24 Dec 2012 22:00:48 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Merry Christmas & Happy New Y

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

2012-12-21 Thread respuzy
Spot on Lalit. Thanks again really grateful Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Lalit Mohan Pandey Date: Fri, 21 Dec 2012 05:56:16 To: Cc: Subject: Re: $$Excel-Macros$$ Re: Vba code to Check authorised users * * * Hi Hilary, Please find the

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 Mo

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 Sender: excel-macros@googlegroups.com Date: Thu, 13 Dec 2012 11:11:20 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Dynamic calendar q

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 Sender: excel-macros@googlegroups.com Date: Thu, 13 Dec 2012 11:11:20 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Dyn

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 i

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: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ A

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 = She

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

2012-12-06 Thread respuzy
Thanks again Prince for your help earlier on this. Additional request The code below enables me to copy data from sheet one to sheet two. The problem I have Ȋ̝̊̅§ One. It doesn't copy the format in sheetone to sheet two. Kindly help with the code Two. This other code "addsheets" that creates a

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 Sender: excel-macros@googlegroups.com Date: Thu, 6 Dec 2012 03:51:53 To: Reply-To: excel-macros@goog

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

2012-12-06 Thread respuzy
Hello experts The below code aids me to add a new sheet and named according to the text in cell A1. What I request Ȋ̝̊̅§ to modify this code to always pick the last item in the row. For instance row 1 has ABX and row A2 has BCD it shd pick BCD as the sheet name if there Ȋ̝̊̅§ a text in say row

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 Sender: excel-macros@googlegroups.com Date: Mon, 3 Dec 2012 23:58:06 To: excel-macros Reply-To: excel-macros@googlegroups.com

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 yo

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 Airt

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

2012-09-21 Thread respuzy
Hi Don Thanks a ton. I have figured a way around it. I found the max of all the equities ie max of say ACI across the years and dragged it across all the other equities and used index and match to find which equity I have selected ie if I select a particular equity its going to give me the max

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: "dg

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" Sender: excel-macros@googlegroups.com Date: Thu, 20 Sep 2012 14:13:37 To: Reply-To: excel-macros@googlegroups.com

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 Sender: excel-macros@googlegroups.com Date: Tue, 28 Aug 2012 13:20:24 To: Repl

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 Sender: exce

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 that

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" Sender: excel-macros@googlegroups.com Date: Sat, 11 Aug 2012 16:49:30 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ BullsEye Chart Hi Group, Just sharing

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 Sender: excel-macros@googlegroups.com Date: Fri, 3 Aug 2012 23:10:25 To: excel-macros Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Noorain An

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 Sender: excel-macros@googlegroups.com Date: Tue, 2

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

2012-07-24 Thread respuzy
Hi Guys Sorry this is not excel related but I needed to share this sad news that the President of the republic of Ghana ♍Ɣ country has just passed away this afternoon. Very sad day here. Sent from my BlackBerry® smartphone from Airtel Ghana -- -- FORUM RULES (986+ members already BANNED for

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 Sender: excel-macros@googlegroups.com Date: Wed, 27 Jun 2012 22:17:47 To: excel-macros Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Fwd: Vis

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 Sender: excel-macros@googlegroups.com Date: Tue, 26 Jun 2012 00:42:36 To: Reply-To: excel-macr

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 Sender: excel-macros@googlegroups.com Date: Fri, 8 Jun 2012 12:21:59 To: Reply-To: excel-macros@googlegroups.com Subject: $$Ex

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 Sender: excel-macros@googlegroups.com Date: Sun, 3 Jun 2012 23:12:31 To: excel-macros Reply-To: excel-macros@googlegroups.com Subject: $$E

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" Sender:

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" Sender: excel-macros@googlegroups.com Date: Sun, 3 Jun 2012 12:33:08 To: Reply-To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Lookup and return

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: Reply-To: excel-macros@googlegroups.com Su

$$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. Kind

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 Sender: excel-macros@googlegroups.com Date: Thu, 24 May 2012 22:42:19 Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Urgent C

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" Sender: excel-macros@googlegroups.com Date: Wed, 16 May 2012 16:08:09 To: Reply-To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Link Check Box many times Hi Hilary,

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 Sender: excel-macros@googlegroups.com Date: Tue, 15 May 2012 13:58:38 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Financial Anal

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" Sender: excel-macros@googlegroups.com Date: Tue, 8 May 2012 16:33:57 To: Reply-To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Date Problem hilary, Instead of TEXT(

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 Sender: excel-macros@googlegroups.com Date: Tue, 8 May 2012 13:00:14 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Date Probl

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 Sender: excel-macros@googlegroups.com Date: Tue,

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 Sender: excel-macros@googlegroups.com Date: Tue, 8 May 2012 11:20:37 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Date Proble

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 Sender: excel-macros@googlegroups.com Date: Wed, 2 May 2012 21:30:32 To: excel-macros Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Rajan verma : Most

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 gra

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 y

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" Sender: excel-macros@googlegroups.com Date: Sun, 15 Apr 2012 16:13:27 To: Reply-To: excel-macros@googlegroups.com Subject: RE: $

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" Sender: excel-macros@googlegroups.com Date: Thu, 5 Apr 2012 11:22:28 To: Reply-To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Amount of words in Re

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 Sender: excel-macros@googlegroups.com Date: Sat, 31 Mar 2012 09:13:04 To: hilary lomotey; Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$

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

2012-03-31 Thread respuzy
Thanks Maries. Will revert with feedback. Thanks Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Maries Sender: excel-macros@googlegroups.com Date: Sat, 31 Mar 2012 09:13:04 To: hilary lomotey; Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macro

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 Date: Sat, 24 M

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 Date: Fri, 23 Mar 2012 21:50:49

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 Sender: excel-macros@googlegroups.com Date: Fri, 23 Mar 2012 08:52:30 To: Reply-To: excel-macros@googlegroups

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: Liyakat

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 Sender: excel-macros@googlegroups.com Date: Tue, 7 Feb 2012 00:40:37 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$

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" Sender: excel-macros@googlegroups.com Date: Mon, 6 Feb 2012 09:50:15 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ TEXT FUNCTION PROBLEM See attached Don

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 Sender: excel-macros@googlegroups.com Date: Wed, 1 Feb 2012 22:17:19 To: Reply-To: excel-macros@googlegroups.com Cc: NOORAIN ANSARI Subject: Re: $$Excel-Macros$$ Most Helpful M