Re: $$Excel-Macros$$ Help Formula to find last date please

2012-03-12 Thread NOORAIN ANSARI
Dear marcio, You can also use.. =INDEX($2:$2,0,LARGE(IF(C3:Z30,COLUMN($C$2:$Z$2),),COLUMN(A2))) with ctrl+shift+enter See attached sheet. -- Thanks regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ On Mon, Mar

Re: $$Excel-Macros$$ Group by Day Issue with Pivot Table

2012-03-12 Thread NOORAIN ANSARI
Dear Jim, Please share your workbook On Sat, Mar 10, 2012 at 6:13 AM, Jim sch...@gmail.com wrote: I'm using Group by Day with 7 days to create the following example: 1/1/2012 - 1/7/2012 1/15/2012 - 1/21/2012 1/22/2012 - 1/28/2012 1/29/2012 - 2/4/2012 1/8/2012 - 1/14/2012- out of

$$Excel-Macros$$ Goal Seek option from Tools menu....(little urgent)

2012-03-12 Thread Mohammed Muneer
Dear Group, I want to select multiple cell values(a1 b1) to change the target cell C1. Can I do it like this? Plz suggest? If any formula or code, anyway that can do well plz send. Regards, Muneer, CC... -- FORUM RULES (986+ members already BANNED for violation) 1) Use

Re: $$Excel-Macros$$ Goal Seek option from Tools menu....(little urgent)

2012-03-12 Thread Abhishek Jain
May be this can help - http://www.vbaexpress.com/kb/getarticle.php?kb_id=433 On Mon, Mar 12, 2012 at 1:42 PM, Mohammed Muneer mmun...@ccc.com.qa wrote: Dear Group, I want to select multiple cell values(a1 b1) to change the target cell “C1”. ** ** Can I do it like this? Plz

$$Excel-Macros$$ Re: Happy new year!!!!!

2012-03-12 Thread SAJID MEMON
hello long time no see!how are you recently?i have bought a laptop on the www.purchasing-bar.com low price ,100% original and i am sure you can find the best item for you !have a try,zolgyfa.com Regards! click here or www.purchasing-bar.com -- FORUM

Re: $$Excel-Macros$$ How to copy text frame from excel and paste in bottom of ppt slide

2012-03-12 Thread rekha siri
hi Asa rossoff, Thanks alot for your advise could please forward the tested macro with these changes. thanks in advance. On Mon, Mar 12, 2012 at 7:37 AM, Asa Rossoff a...@lovetour.info wrote: Hi Rekha, You can change the line that sets the vertical position from:

Re: $$Excel-Macros$$ Add business address in a single row

2012-03-12 Thread dguillett1
A macro approach. Sub lineemupSAS() Dim i As Long Dim j As Integer Application.ScreenUpdating = False For i = 1 To Cells(Rows.Count, 2).End(xlUp).Row Step 4 For j = 1 To 4 Cells(i, j + 2).Value = Cells(j + 1, 2).Value Next j Next i ‘clean up

Re: $$Excel-Macros$$ help on copy and past data needed

2012-03-12 Thread dguillett1
You can help yourself learn. Record a macr while select your rangedatafilterfilter by datecopy/paste to other sheetunfilter. clean it up to use for next time. Post back your results Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Monday,

$$Excel-Macros$$ link Excel files (Excel table) in MS-word with MS Excel files.

2012-03-12 Thread chhajersandeep
Dear Excel gurus, I want to link my excel table which is in MS WORD as table with other MS EXCEL file. Can it be possible with any macros. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles.

$$Excel-Macros$$ Logical Formula Problem

2012-03-12 Thread hilary lomotey
Hi Experts i am trying to use the logical formula ie or operator to have an outcome such that if the figure in say cell A is greater than that of cell B, i want it to read is higher than, if false then lesser than, this would be achieved by selecting the year from the drop down, i have done

Re: $$Excel-Macros$$ Syntax used in VBA

2012-03-12 Thread Dilip Pandey
Nice collection ... Noorain. Regards, DILIPandey On Mon, Mar 12, 2012 at 12:44 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Hi dnkndnkn, Please find attached Ebook for VBA beginner. On Sun, Mar 11, 2012 at 6:21 PM, dnkndnkn dnknd...@gmail.com wrote: The syntax of VBA is different

$$Excel-Macros$$ Chart problem with selection

2012-03-12 Thread Grzegorz Lippe
Hello :) I have a problem with an active selection in Excel, which I couldn't resolve using google... I'm writing a makro which at some point uses the Chars.Add Method. Now if there was a previously selected range it is automaticly inclouded in the diagram. How can I avoid this? Thanks! :)

$$Excel-Macros$$ Load Excel file in another Excel file

2012-03-12 Thread Mayank
Hi team, Need help here: I have a Master file having 5 tabs; 1st tab is Master tab which populated through other 4 tab's data. Source of those 4 tabs are four differet excel file having multiple tabs in it and a specific tab's data to be loaded in Master file's specific tab. Thanks

$$Excel-Macros$$ Help Needed

2012-03-12 Thread Patil MG
Dear Experts, I have to create 'N' number of empty files of word and note pad files, this word will long time to do can any one help to write a macro where in which i can create empty word files or note pad files by running the macro, my files will be listed in excel file (please refer the

Re: $$Excel-Macros$$ Logical Formula Problem

2012-03-12 Thread dguillett1
See if this simpler approach is helpful Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: hilary lomotey Sent: Monday, March 12, 2012 10:22 AM To: excel-macros Subject: $$Excel-Macros$$ Logical Formula Problem Hi Experts i am trying to use the logical formula ie

Re: $$Excel-Macros$$ copy range

2012-03-12 Thread LearnExcel
hey Don, i didnt get the sheet can re-send it again On Mar 9, 8:59 am, dguillett1 dguille...@gmail.com wrote: I sent a “solved macro for this” Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Selva Loganathan Sent: Thursday, March 08, 2012 8:31 PM To:

Re: $$Excel-Macros$$ Chart problem with selection

2012-03-12 Thread NOORAIN ANSARI
Dear Lippe Please use *charts.Add* instead of Chars.Add -- Thanks regards, Noorain Ansari *http://noorainansari.com/* http://excelmacroworld.blogspot.com/ *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ On Mon, Mar 12, 2012 at 2:25 PM, Grzegorz Lippe

Re: $$Excel-Macros$$ Load Excel file in another Excel file

2012-03-12 Thread NOORAIN ANSARI
Dear Mayank, Please share your workbook with excel-macro group. -- Thanks regards, Noorain Ansari *http://noorainansari.com/* http://excelmacroworld.blogspot.com/ *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ On Mon, Mar 12, 2012 at 3:16 PM, Mayank

Re: $$Excel-Macros$$ link Excel files (Excel table) in MS-word with MS Excel files.

2012-03-12 Thread xlstime
you can use paste special link function .. On Mon, Mar 12, 2012 at 8:13 PM, chhajersand...@gmail.com wrote: Dear Excel gurus, I want to link my excel table which is in MS WORD as table with other MS EXCEL file. Can it be possible with any macros. Sandeep Chhajer. Sent on my BlackBerry®

$$Excel-Macros$$ Format data from Tally 7.2

2012-03-12 Thread Rajesh K R
Hi experts, I have a large data in Tally 7.2,when i try to I got data in a different format, please check the attached file Sheet 2 and make a solution. Thanks in advance Rajesh Kainikkara -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor