$$Excel-Macros$$ Re: If Conditions - Urgent Help Required
Hi Abhishek, I hope this will help you. =IF(A2=A+,IF(B2=Cartons,IF(C2=1,Yes,No),IF(B2=Bales,IF (C2=1.5,Yes,No),IF(B2=Pallets,IF(C2=2,Yes,No),IF (B2=Others,IF(C2=3,Yes,No),) This formula assumes that Column A, B and C contains Category, Type of Cargo and Time taken respectively. Also remove the hour/hours in time taken using find and replace. Cheers, Valli On Jan 22, 1:35 am, Abhishek Jain abhishek@gmail.com wrote: * URGENT* Hi friends, Please help me on this: Category Type of Cargo Time taken A+ Cartons 1 hour A+ Bales 1.5 hours A+ Pallets 2 hours A+ Others 3 hours I want to check the time taken and show the result as Yes or No as detailed hereunder - If the category is *not equal to* A+ *- formula should return FALSE*(this is the first condition to be checked) If category is A+ and Type of Cargo is Cartons and Time taken is more than 1 hour - it should say Yes If category is A+ and Type of Cargo is Bales and Time taken is more than 1.5 hour - it should say Yes If category is A+ and Type of Cargo is Pallets and Time taken is more than 2 hours - it should say Yes If category is A+ and Type of Cargo is Others and Time taken is more than 3 hours - it should say Yes Else It should say No Please help me writing an if statement (or whatever that works) for this. Thanks in advance, Best regards, AJ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Exporting data using Pulldown List
HI SANDIP if you need any other clarification , plz let me know Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Fri, Jan 22, 2010 at 1:24 PM, ankur ankurpande...@gmail.com wrote: HI SANDIP check the revised sheet, this is acc to ur need if you want formulas in next rows and cloumns just drag the last row Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Fri, Jan 22, 2010 at 6:24 AM, Sandip Patel myitems2...@gmail.com wrote: Hi Ankur, Really appreciate your help. It is working as I wanted. But When I change the symbol in column A, it is giving an error. Please see the attached file. Is it possible that it allows me to enter the symbol in any sequence, as long I have all the required values of that particular symbol in the next sheet. Also, in the excel sheet you send me, the formulas are in the rows 1 to 5. Is there any way I can have the same formula in the remaining rows/column, even though they are empty? Regards, Sandip -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of ankur Sent: Wednesday, January 20, 2010 9:01 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Exporting data using Pulldown List hi sandip plz check the attached file i think this is what you want On 21/01/2010, Sandip Patel myitems2...@gmail.com wrote: Hi Friends, I am developing a portfolio tracker excel file. I am having some difficulty in implementing one function, which I think I cannot create using macro. As you can see in the attached file, in the sheet Data, I am downloading various parameters using the SMF Add-In. Which is working fine. After downloading these data I want to export them into the other sheet Pull Down Option. I tried to use OFFSET and VLOOKUP function. But it is not working. In the Pull Down Option sheet, I have created a droop down list, so when I change the droop down list, the data associated (Sheet Data) with it should change. Regards, Sandip -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they
Re: $$Excel-Macros$$ Excel can Speak now
hi, vedar this is only aplicble in VBA code or n normal excell file please r/shiva On 1/21/10, Dhananjay Pinjan dppin...@gmail.com wrote: Please send me the Excel File Thanks Regards, Dhananjay On Thu, Dec 31, 2009 at 12:41 AM, Vishal Parihar vish.pari...@gmail.comwrote: Hi Friends The below code are to use:- Application.Speech.Speak (vishal parihar) Regards Vishal Parihar I hope you will like it. -- -- Some important links for excel users: 1. Follow us in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Thanks Regards Shivashankar.C.Katageri. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ delete row only the next mob no same
*hi, it will help U* Public Sub DeleteDuplicateRows() Dim R As Long Dim N As Long Dim V As Variant Dim Rng As Range On Error GoTo EndMacro Application.ScreenUpdating = False Application.Calculation = xlCalculationManual Set Rng = Application.Intersect(ActiveSheet.UsedRange, _ ActiveSheet.Columns(ActiveCell.Column)) Application.StatusBar = Processing Row: Format(Rng.Row, #,##0) N = 0 For R = Rng.Rows.Count To 2 Step -1 If R Mod 500 = 0 Then Application.StatusBar = Processing Row: Format(R, #,##0) End If V = Rng.Cells(R, 1).Value If V = vbNullString Then If Application.WorksheetFunction.CountIf(Rng.Columns(1), vbNullString) 1 Then Rng.Rows(R).EntireRow.Delete N = N + 1 End If Else If Application.WorksheetFunction.CountIf(Rng.Columns(1), V) 1 Then Rng.Rows(R).EntireRow.Delete N = N + 1 End If End If Next R EndMacro: Application.StatusBar = False Application.ScreenUpdating = True Application.Calculation = xlCalculationAutomatic MsgBox Duplicate Rows Deleted: CStr(N) End Sub On Fri, Jan 22, 2010 at 12:10 PM, manoj kumar kumar1...@gmail.com wrote: Hi Sir I have a list of several thousands email in it but there are so many emails same I have sorted the list but cannot delete all the files which are copied of the above row please help -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Ganesh Gawde -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ If Conditions - Urgent Help Required
hi abhishek check the attached file, i think this is what you needed Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Fri, Jan 22, 2010 at 2:05 AM, Abhishek Jain abhishek@gmail.com wrote: URGENT Hi friends, Please help me on this: Category Type of Cargo Time taken A+ Cartons 1 hour A+ Bales 1.5 hours A+ Pallets 2 hours A+ Others 3 hours I want to check the time taken and show the result as Yes or No as detailed hereunder - If the category is not equal to A+ - formula should return FALSE (this is the first condition to be checked) If category is A+ and Type of Cargo is Cartons and Time taken is more than 1 hour - it should say Yes If category is A+ and Type of Cargo is Bales and Time taken is more than 1.5 hour - it should say Yes If category is A+ and Type of Cargo is Pallets and Time taken is more than 2 hours - it should say Yes If category is A+ and Type of Cargo is Others and Time taken is more than 3 hours - it should say Yes Else It should say No Please help me writing an if statement (or whatever that works) for this. Thanks in advance, Best regards, AJ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe if condition solution by ankur.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Excel can Speak now
hi shivashankar this is vba code, you have to write this code in vb project , Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Fri, Jan 22, 2010 at 2:01 PM, shivashankar katageri shankarkatag...@gmail.com wrote: hi, vedar this is only aplicble in VBA code or n normal excell file please r/shiva On 1/21/10, Dhananjay Pinjan dppin...@gmail.com wrote: Please send me the Excel File Thanks Regards, Dhananjay On Thu, Dec 31, 2009 at 12:41 AM, Vishal Parihar vish.pari...@gmail.com wrote: Hi Friends The below code are to use:- Application.Speech.Speak (vishal parihar) Regards Vishal Parihar I hope you will like it. -- -- Some important links for excel users: 1. Follow us in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Thanks Regards Shivashankar.C.Katageri. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
RE: $$Excel-Macros$$ Delete rows only if the entire row is empty
Hi Vinrod, You could use this in the sheet window: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Selection.Columns.Count = 256 Then If Application.WorksheetFunction.CountA(Selection) 0 Then MsgBox (Row not empty. Entire Row cannot be selected.) Cells(Selection.Row, 1).Select End If End If End Sub If you are using XL2007, you'll have to change the Columns count. Regards - Dave. From: nvino...@gmail.com Date: Fri, 22 Jan 2010 11:26:34 +0530 Subject: $$Excel-Macros$$ Delete rows only if the entire row is empty To: excel-macros@googlegroups.com Dear Gurus, Macro or any other way in excel where the user should be able to delete rows only if the entire row is empty... Please help... -- Thanks and Regards Vinod N -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe _ Shopping Trolley Mechanic If It Exists, You'll Find it on SEEK http://clk.atdmt.com/NMN/go/157639755/direct/01/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: Delete rows only if the entire row is empty
hi vinod check this link http://www.cpearson.com/excel/deleting.htm On Jan 22, 10:56 am, Vinod N nvino...@gmail.com wrote: Dear Gurus, Macro or any other way in excel where the user should be able to delete rows only if the entire row is empty... Please help... -- Thanks and Regards Vinod N -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Unlock Cells on Condations
Hi Dave, Thanks for your code. I was looking for columns only. Your code is working perfectly. I have one more criteria needs to be included in this. Can you include yesterday along with Today in the unlock columns? Please let me know if you have any questions. Regards, Selva On Thu, Jan 21, 2010 at 7:28 AM, Dave Bonallack davebonall...@hotmail.comwrote: Hi, Your request is a bit confusing. You say that your dates are B1:B32. So today's date will be - lets say, in B10. It seems that you want to unlock Row 10, not a column. However, I've written code to unlock *columns* (as requested) but with dates in A1:AA1. If you want to unlock Rows, the code will have to be rearranged. Private Sub Worksheet_Activate() ActiveSheet.Unprotect Columns(A:AA).Locked = True With Range(A1:AA1) Set c = .Find(Date, LookIn:=xlFormulas, lookat:=xlWhole) If Not c Is Nothing Then Columns(c.Column).Locked = False End With ActiveSheet.Protect End Sub Also, see attached. Presently the sheet is protected without a password. Regards - Dave. Date: Tue, 19 Jan 2010 15:42:22 -0800 Subject: $$Excel-Macros$$ Unlock Cells on Condations From: s.selvarathi...@gmail.com To: excel-macros@googlegroups.com Hi, I need some assistance in unlocking a range of cells based on date conditions For example, B1:B32 has dates for the month and based on today's date, it should unlock the entire column to allow the user to enter the data. It should not allow the user to enter data for yesterday or tomorrow... Cell should be open only for today's date. Thanks for your help. -- Sell your old one fast! Time for a new car?http://clk.atdmt.com/NMN/go/157637060/direct/01/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Thanx Regards, Selvarathinam. C.S -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Help me
Dear Abdul One way can be pasting all the addresses in the field BCC of the mail specifying your mail id in the field TO of the mail . Regards Jatin On Fri, Jan 22, 2010 at 8:48 PM, Abdul Rasheed rashee...@gmail.com wrote: i have a list of e-mail address on one exel sheet and documents on other (word, note pad, pdf) format and i want to email one document to all e-mail address. is it possible with help of excel. Regards, Abdul Rasheed Confidence never comes if we have all the answers, Be ready for all the questions... .Be bold to face the world -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Excel Data Automator
I've written an Excel Add-in to help me coworkers to perform automated data extraction from various data sources. It's been very well received in my company, so I want to share it out. I've made a simple site, the link is here: https://sites.google.com/site/exceldataautomator/ The add-in is free to download. No spam, no virus. Please let me know if you have any comments, requests, especially if you find bugs. This is not an ad. I just want to get more feedback from high-end users to get a chance to improve. Thanks. Paul -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ VBA code to delete all unused rows and columns
I'm looking to set up some VBA code to delete blank rows and columns that just take up space in spreadsheets that I get from external sources. ie: data is in 1 column(A), rows 1-10, if you place a cursor in A1 and hit end down, you go to cell A64000. So delete all empty columns, then rows, then reset excels last cell to whatever it is. Any ideas on this code? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Function to return days by month
I need help. I have a Start Date and End Date, formated as date. I need to calculate the days by month covered by this start/end. Example is attached. Also, based on the days by month, I need to calendarize assignment by resource (see attached file). I CAN NOT use in this model any of the Analysis Toolpack functions. I CAN use VBA UDF. Thanks, Cecilia _ ¡Seducción! 249 historias cada semana en el sitio nº1 para conseguir una cita. ¡Regístrate! http://contactos.es.msn.com/?mtcmk=015352 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Days between months.xls Description: Binary data
RE: $$Excel-Macros$$ Excel Data Automator
Hi Paul, I've installed the add-in, but when I select Control Panel, I get an error message Cannot open key I'm using XL2000 Regards - Dave. Date: Fri, 22 Jan 2010 13:04:40 -0800 Subject: $$Excel-Macros$$ Excel Data Automator From: pau...@gmail.com To: excel-macros@googlegroups.com I've written an Excel Add-in to help me coworkers to perform automated data extraction from various data sources. It's been very well received in my company, so I want to share it out. I've made a simple site, the link is here: https://sites.google.com/site/exceldataautomator/ The add-in is free to download. No spam, no virus. Please let me know if you have any comments, requests, especially if you find bugs. This is not an ad. I just want to get more feedback from high-end users to get a chance to improve. Thanks. Paul -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe _ Search for properties that match your lifestyle! Start searching NOW! http://clk.atdmt.com/NMN/go/157631292/direct/01/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Automatic goal seek...
Hi frds. plz anyone tell me, is ther ny way to us goal seek automatic calculation... I'v data in which I do always chng variables..n thn i apply goal seek.. but i want automatic goal seek operation shld apply as soon as i chng variable data.. thnx in advance.. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe