Re: $$Excel-Macros$$ Linking of Excel data to powerpoint file

2012-07-21 Thread David Grugeon
Hi Amit You should be able to use Paste Special - Link in Powerpoint. Kind regards David Grugeon On 21 July 2012 13:49, Amit Desai (MERU) amit.de...@merucabs.com wrote: Dear Masters, ** ** We used to keep updating tables in excel sheet then used to paste this tables in ppt.

$$Excel-Macros$$ Help needed to count and sum data between two fixed dates.

2012-07-21 Thread santosh subudhi
Hi Group, Need another help to count and sum data between two fixed dates. Regards Santosh santoshkumar.subu...@gmail.com -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula

Re: $$Excel-Macros$$ Help for macros

2012-07-21 Thread dguillett1
When you ask for help: Provide a meaningful subject line Provide a file with before/after examples and the logic of why/where Tell us what you want where and why. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: dharmesh rav Sent: Saturday, July 21, 2012 1:19

Re: $$Excel-Macros$$ Help needed to count and sum data between two fixed dates.

2012-07-21 Thread dguillett1
Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: santosh subudhi Sent: Saturday, July 21, 2012 6:08 AM To: excel-macros Subject: $$Excel-Macros$$ Help needed to count and sum data between two fixed dates. Hi Group, Need another help to count and sum data

$$Excel-Macros$$ Required Prefix Macro for the numbers

2012-07-21 Thread Puttu *
Hi Experts, Please help on below macro need a macro to prefix on the below numbers. I just took one one example for refeence, but i have huge no. like this. Your help is much appreciated *Number* *Outlet* *Level* *Code should some thing like this* *This is how I am looking for output* 100

Re: $$Excel-Macros$$ urgent need for java/flex developer

2012-07-21 Thread Ayush Jain
Banned On Thursday, 19 July 2012 08:30:36 UTC+5:30, NOORAIN ANSARI wrote: Dear Ayush, Please ban it.. On Thu, Jul 19, 2012 at 3:27 AM, uma sindhu umagethi...@gmail.com wrote: Hi, Hope you are doing good!!! We have an Urgent need Java/Flex developer with one of our client.

RE: $$Excel-Macros$$ Linking of Excel data to powerpoint file

2012-07-21 Thread Amit Desai (MERU)
Sure will try that...thanks. Best Regards, Amit From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of David Grugeon Sent: 21 July 2012 12:27 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Linking of Excel data to powerpoint file Hi Amit You

$$Excel-Macros$$ Re: Error Cleaning

2012-07-21 Thread bpascal123
This line should allow you to run this macro from the workbook where the data is ... if the file is not xlsx (it can then be xls, xlsm, xlsb ) Set wbIn = ThisWorkbook (the line...worksheet add... that was commented out i forgot to delete wouldn't work anyway-i just found it easier to run the

Re: $$Excel-Macros$$ Required Prefix Macro for the numbers

2012-07-21 Thread dguillett1
Modify to suit Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Puttu * Sent: Saturday, July 21, 2012 8:45 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Required Prefix Macro for the numbers Hi Experts, Please help on below macro need a macro to

Re: $$Excel-Macros$$ Required Prefix Macro for the numbers

2012-07-21 Thread Puttu *
Thanks Don, but i need a macro for this, because i have too many sheets in the same format. Macro will help me a lot to save my time On Sat, Jul 21, 2012 at 9:53 PM, dguillett1 dguille...@gmail.com wrote: Modify to suit Don Guillett Microsoft Excel Developer SalesAid Software

$$Excel-Macros$$ need formulae to pick next highest value by checking two values - 1) text and 2) number

2012-07-21 Thread vijay yadav
Dear Friends/ Excel Experts I need formulae to pick next highest value by checking two input values 1) text and 2)number input cells are A53 (TEXT) and A54(NUMBER) formuale should OUTPUT NEXT highest value to number in A54 TEXT IS COMPARED TO A NUMBER OF TEXT ENTRIES IN ROW 1 AND NUMBER

Re: $$Excel-Macros$$ Required Prefix Macro for the numbers

2012-07-21 Thread dguillett1
It’s easy enough to use a macro to apply the vlookup formula, assuming you have the table set up or you could use a SELECTCASE macro. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Puttu * Sent: Saturday, July 21, 2012 11:53 AM To:

Re: $$Excel-Macros$$ need formulae to pick next highest value by checking two values - 1) text and 2) number

2012-07-21 Thread Sam Mathai Chacko
As a MOF, 6150FLA is in Column L also. What is your logic of using the second instance of this value? On Sat, Jul 21, 2012 at 11:30 PM, Sam Mathai Chacko samde...@gmail.comwrote: Column G also has the same text as column header. How do you decide whether it is column G, or column I?? Sam

Re: $$Excel-Macros$$ need formulae to pick next highest value by checking two values - 1) text and 2) number

2012-07-21 Thread Sam Mathai Chacko
Anyway, if you want to pick the last column, use =INDEX(OFFSET($A$2:$A$22,0,MATCH(A53,$B$1:$V$1)),MATCH(A54,OFFSET($A$2:$A$22,0,MATCH(A53,$B$1:$V$1)),1)+1) If you want to pick the first column, use

$$Excel-Macros$$ Microsoft unveils the new Office 2013

2012-07-21 Thread yogananda muthaiah
H, *Microsoft unveils the new Office 2013* http://www.microsoft.com/office/preview/en/excel-2013-preview For developers : http://msdn.microsoft.com/en-us/library/office/jj229830(v=office.15) -- Regards Yogananda Muthaiah Ph : 973 123 7267 -- -- FORUM RULES (986+ members already BANNED

$$Excel-Macros$$ Excel 2015 and Excel 2013 screnshots attached

2012-07-21 Thread yogananda muthaiah
-- [image: ms-office-2013-excel]http://www.dvd-ppt-slideshow.com/blog/wp-content/uploads/2012/07/ms-office-2013-excel.jpg Regards Yogananda Muthaiah Ph : 973 123 7267 -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles,

$$Excel-Macros$$ Re: need formulae to pick next highest value by checking two values - 1) text and 2) number

2012-07-21 Thread vijay yadav
Great, This was exactly what i wanted, Please help me to get some more values in same row under the headers-HEADER,RPM,GD sq and of the adjacent row All these values are from the same row as the row from where the output had come Please see the attached file Thanks for you very very

Re: $$Excel-Macros$$ Required Prefix Macro for the numbers

2012-07-21 Thread Puttu *
Please help me on this experts On Sat, Jul 21, 2012 at 7:15 PM, Puttu * puttu...@gmail.com wrote: Hi Experts, Please help on below macro need a macro to prefix on the below numbers. I just took one one example for refeence, but i have huge no. like this. Your help is much appreciated