$$Excel-Macros$$ utilities magnifying glass in ppt

hi is there someone can help me? I'd have to insert the effect of magnifying glass in a powerpoint application in order to zoom various part of a differente fotoes... does exist a mode to do this? thank's to all paola -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise

Re: $$Excel-Macros$$ Re: Need help with screen tip

All sorry to be a pain... But is there some way that this can be done?? Thanks for all your help. Sent on my BlackBerry® from Vodafone -Original Message- From: krishnanm2...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 7 Nov 2011 03:32:14 To: Reply-To: excel-macros@googleg

Re: $$Excel-Macros$$ Chart needed

https://www.google.com/#sclient=psy-ab&hl=en&source=hp&q=EXCEL%3A+second+series&pbx=1&oq=EXCEL:+second+series&aq=f&aqi=g-v1g-b1&aql=&gs_sm=e&gs_upl=3086l6322l1l6543l13l11l0l0l0l0l317l1624l2.7.1.1l11l0&bav=on.2,or.r_gc.r_pw.,cf.osb&fp=87af38fe187deaa2&biw=888&bih=559 tiny url http://tinyurl.com/6w

$$Excel-Macros$$ Time conversion

Is there a way I can convert a Central Time Zone value into an Eastern Time Zone value? I have a column of data that contains a date / time value that's central. I want to have another column that converts it to ET (+2 hours). How can I do that with a formula? Thanks For example: Central Tim

Re: $$Excel-Macros$$ How to use Advance filter

Dear Sandeep, Please see attached sheet..if it help to u On Sun, Nov 6, 2011 at 10:11 AM, wrote: > Dear all, > > Please help me to learn how to use advance filter. > I have tried to google to learn it but could not get it correct. > Please help me learn it in excel 2007 version. > > Sandeep Chh

Re: $$Excel-Macros$$ Time conversion

=A2+(2/24) Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: RockyFontane Sent: Tuesday, November 08, 2011 7:52 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Time conversion Is there a way I can convert a Central Time Zone value into an Eastern T

Re: $$Excel-Macros$$ Indian formats

Dear Mothilal, you can also try http://chandoo.org/wp/2010/07/26/indian-currency-format-excel/ -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On

Re: $$Excel-Macros$$ Re: Need help with screen tip

Like I mentioned yesterday, you can use hyperlinks with custom screen tips in small shapes placed on top of your actual image, and make those shapes transparent. If you need an example of how this can be done, revert. Regards, Sam Mathai Chacko On Tue, Nov 8, 2011 at 10:34 AM, wrote: > All sor

$$Excel-Macros$$ sumary of worksheet's names

Hi! How can I create a sumary with all the worksheet's name of the workbook? Thanks -- FORUM RULES (925+ 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 will n

Re: $$Excel-Macros$$ sumary of worksheet's names

Your question is not clear. The sample you attached just shows the name of the sheets listed, except the first sheet. What does that indicate? Can you be a little more descriptive of what you require. Regards, Sam On Tue, Nov 8, 2011 at 8:26 PM, Chamili Coelho da Costa wrote: > Hi! > > How can I

Re: $$Excel-Macros$$ sumary of worksheet's names

Check this link and let me know this was helpful. "http://sourcedaddy.com/ms-excel/create-list-worksheet-names.html"; Sent on my BlackBerryŽ from Vodafone -Original Message- From: Chamili Coelho da Costa Sender: excel-macros@googlegroups.com Date: Tue, 8 Nov 2011 12:56:20 To: Reply-To:

Re: $$Excel-Macros$$ utilities magnifying glass in ppt

There's a zoom option in the view area, but that would be for the entire slide. I do not think there is a magnifying glass option in powerpoint, at least till Excel 2010. Regards, Sam On Tue, Nov 8, 2011 at 5:45 PM, Paola wrote: > hi > > is there someone can help me? > > I'd have to insert the

Re: $$Excel-Macros$$ Re: Need help with screen tip

Sam thanks so much for the response... Would you pls let me know if I can link screen tips to a particular cell?? In a nutshell what I am trying to say is, my data will change every month and I need something by which my screen tips will change month on month... Kindly let me know.. Thanks for

$$Excel-Macros$$ Understand Formula

Hello Group, Following formula is working fine & picking desire word from cell within colons, Only "MID" & "SEARCH" formula is understandable but I am not understanding the syntax of this formula how is it working? Please brief & tell me why +1 & -1 added. How to make & understand of these ty

Re: $$Excel-Macros$$ sumary of worksheet's names

Dear Chamili, SAM's statement is right, your question is not more clear. if you want only Sheet's Name you can try.. Sub Summary_sheet() Dim i, sh As Integer Sheet1.Cells(1, "A").Value = "Summary" sh = Sheets.Count For i = 2 To sh Sheet1.Cells(i, "A").Value = Sheets(i).Name Next i End Sub -- T

Re: $$Excel-Macros$$ Understand Formula

So the formula is just trying to extract a word in a sentence that is wrapped between double quote. So if the sentence is for example This is "Sam" The result of the formula would be Sam How the formula works is simple if you know how search works. So I'll just explain how search works The Sea

Re: $$Excel-Macros$$ sumary of worksheet's names

In Excel Version Write formula in refers To Under Formula ->Define Name =REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1)),"") Paste it in Cell A1 =IF(ROWS($A$2:A2)<=COUNTA(SheetNames),INDEX(SheetNames,ROWS($A$2:A2)*ROUNDUP(RAND(),0)),"") -- Thanks & regards, Noorain Ansari *http:/

Re: $$Excel-Macros$$ sumary of worksheet's names

In Noorain's solution, the name of the defined name formula would be * SheetNames* Also, you can find here a UDF through VBA as well http://www.excelfox.com/forum/f13/list-all-worksheet-names-using-formula-119/ Regards, Sam Mathai Chacko On Tue, Nov 8, 2011 at 11:40 PM, NOORAIN ANSARI wrote:

Re: $$Excel-Macros$$ Understand Formula

SAM evaluation may be just checking the formula, your description is too enough but can you further brief the structure. Aamir Shahzad On Tue, Nov 8, 2011 at 10:52 PM, Sam Mathai Chacko wrote: > So the formula is just trying to extract a word in a sentence that is > wrapped between double quote

$$Excel-Macros$$ Macro To Add a Cell From A List And Create A New Tab

I have a spreadsheet with a tab called Form. There is a second tab called Vehicle List. I need a macro to take the first vehicle on the list and put that number in cell D56 of the form tab and then copy the tab and repeat this process until all the vehicle numbers are on the form in their own tab

Re: $$Excel-Macros$$ Macro To Add a Cell From A List And Create A New Tab

Try this: Sub Make_Sheets()     Dim vCnt, vNum     ThisWorkbook.Activate     Sheets("Form").Select     Application.ScreenUpdating = False     vCnt = Application.WorksheetFunction.CountA(Sheets("Vehicle List").Range("A1:A65000"))     For vNum = 2 To vCnt     Sheets("Form").Copy After:=Sheets(3

Re: $$Excel-Macros$$ Macro To Add a Cell From A List And Create A New Tab

Use this macro and be sure to save your file as an .xls or .xlsm Sub MakeSheetsFromVehicleList() Sheets("Vehicle List").Select Dim c As Range Dim lr As Long lr = Cells(Rows.Count, 1).End(xlUp).Row For Each c In Range("a2:a" & lr) With Sheets("form") Range("d56").Value = c .Copy after:=ActiveSheet

$$Excel-Macros$$ help: excel changes macro assignment

Hi alli am looking for help with an issue that is bugging me no end. I have assigned a macro to a button which works well until i double click on a cell which launches a macro to mine data and then use this to get information out of a pivot ...this data is then dumped onto a Jew workbook. Th

Re: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 35 Messages in 9 Topics

Hi, for several weeks all the links to further details have not been working on any devices with which I'm connecting to this excellent group. Like more... Please let me know what I need to do to make it work again. Regards Jørgen Bugge On Nov 7, 2011 11:34 PM, wrote: > Today's Topic Summary

Re: $$Excel-Macros$$ Indian formats

More Thanks for informations Mothilal.J On Tue, Nov 8, 2011 at 8:18 PM, NOORAIN ANSARI wrote: > Dear Mothilal, > > you can also try > http://chandoo.org/wp/2010/07/26/indian-currency-format-excel/ > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/*