$$Excel-Macros$$ Link Query
Dear Group, I want to know about how could link more excel sheet in one file without hypper link. Please explain have tools in excel. Thanks, Prabhakar Thakur New Delhi +919953736776 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Urgent Query
Dear All, I have data for two years arranged in 2 columns respectively. Example. *Yr1* *Yr 2* A A B B C C D D F H I Now i want is to make a combined list (lets say in column 3) but there should be no repetitions in this list (as in the above example, after combining, i should only see one A.. or one B). This is just an example and my actual data is huge... Pls suggest something to do this process quickly... Thanks Rgds, Anubhav -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Urgent Query
Dear Anubhav, Please see attachement.. Thanks, Noorain Ansari On Thu, Jan 13, 2011 at 1:45 AM, Anubhav Somani anubhav.som...@gmail.comwrote: Dear All, I have data for two years arranged in 2 columns respectively. Example. *Yr1* *Yr 2* A A B B C C D D F H I Now i want is to make a combined list (lets say in column 3) but there should be no repetitions in this list (as in the above example, after combining, i should only see one A.. or one B). This is just an example and my actual data is huge... Pls suggest something to do this process quickly... Thanks Rgds, Anubhav -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks regards, Noorain Ansari -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Book1.xlsm Description: Binary data
Re: $$Excel-Macros$$ Clear Contents based on another cell value
Thanks Ashish Thanks Dave. - Manish On Jan 13, 7:14 am, Dave Bonallack davebonall...@hotmail.com wrote: Hi Manish, Place this code in the appropriate VBA sheet window Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Column = 2 Then Cells(Target.Row, 3).ClearContents End Sub Hope this helps Regards - Dave. Date: Wed, 12 Jan 2011 02:27:22 -0800 Subject: $$Excel-Macros$$ Clear Contents based on another cell value From: pansari.man...@gmail.com To: excel-macros@googlegroups.com Hello friends, I need a small help. I want the VBA code for following task. If someone change the value in B2 column, macro will clear the value of C2 column. If someone change the value in column B3, macro will clear the value of column C3 and so on... Please suggest me the code. Thanks in advance. Thnxs, Manish -- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel- Hide quoted text - - Show quoted text - -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Offset Range Copy
Hello Group, Can anyone help me with this “simple” line of code. I need a line that will allow me to: Starting at the cell I’m in, Extend right for 200 cells Activate the cells copy I want to use easy code ie along the lines of ActiveCell.Offset(0,200).Range.Select Or Range.ActiveCell.Offset(0,200).Copy As that’s what I’m most familiar with Any suggestions? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Extract data between two dates
Dear experts, Please help me on my quary. I have date wise depot wise product wise sale amount. I need to extract sale between two dates matching with other two criteria(Depot Product). I have tried sumifs sumproduct formula, but result is not coming properly. Please help Thanks in advance Kalyan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Extract data between two dates.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Formula of the week - share your best formula
Dear members, We all come to know about many functions their best uses. Please keep sharing. Thanks. Best Regards, Ayush Jain -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Extract data between two dates
check the attachment see if it helps On Thu, Jan 13, 2011 at 7:11 PM, Kal xcel kalx...@gmail.com wrote: Dear experts, Please help me on my quary. I have date wise depot wise product wise sale amount. I need to extract sale between two dates matching with other two criteria(Depot Product). I have tried sumifs sumproduct formula, but result is not coming properly. Please help Thanks in advance Kalyan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Extract_data_between_two_dates(1).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ IF two criteria then count occurrences of TRUE
attachement missing On Thu, Jan 13, 2011 at 7:11 PM, mikeb mb...@allstate.com wrote: I would appreciate some help with the following. I am trying to use two criteria and if they are true then count the occurrences of the work “TRUE” in a specified column, I have attached a sample worksheet using excel formulas; however I would not object to using VBA to accomplish the task. I actually have many different types of tests to do, I am only showing one; if we can solve this I will just extrapolate for the other tests. Any help will be greatly appreciated. Thank you, MikeB -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Extract data between two dates
Hi Kalyan, Attached file has been solved per your requirement(s). :) Let me know if this works. Best Regards, DILIPandey On Thu, Jan 13, 2011 at 7:11 PM, Kal xcel kalx...@gmail.com wrote: Dear experts, Please help me on my quary. I have date wise depot wise product wise sale amount. I need to extract sale between two dates matching with other two criteria(Depot Product). I have tried sumifs sumproduct formula, but result is not coming properly. Please help Thanks in advance Kalyan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks Regards, DILIP KUMAR PANDEY, mvp MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Extract data between two dates.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Offset Range Copy
try this Range(ActiveCell, ActiveCell.Offset(0, 200)).Copy On Thu, Jan 13, 2011 at 7:06 PM, iggy-mac iggy-...@telinco.co.uk wrote: Hello Group, Can anyone help me with this “simple” line of code. I need a line that will allow me to: Starting at the cell I’m in, Extend right for 200 cells Activate the cells copy I want to use easy code ie along the lines of ActiveCell.Offset(0,200).Range.Select Or Range.ActiveCell.Offset(0,200).Copy As that’s what I’m most familiar with Any suggestions? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: Re: $$Excel-Macros$$ Formula of the week - share your best formula
Hi All, from my side. =INT() On Jan 13, 2011 9:04pm, kiran Kancharla srkira...@gmail.com wrote: Hi All, from my side I am adding 2 formulas. 1.Index 2.Match One of the best functions.. Please have a look on the Attachment.. Thanks Regards, Kiran On Thu, Jan 13, 2011 at 8:46 PM, Ayush jainayus...@gmail.com wrote: Dear members, We all come to know about many functions their best uses. Please keep sharing. Thanks. Best Regards, Ayush Jain -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Formula of the week - share your best formula
Hi All, I suggest all of you don't say this function I like and then this one like that. Just sharing the function name won't help others to gain some knowledge. All the functions which is available in excel is having the same set of qualities unless it is used in perfect combination. So give brief about the function and its different type of usages which you came across in your past. Hope this makes sense. --- Ms.Exl.Learner --- -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Formula of the week - share your best formula
Hi All, From My Side, Best Formula is Match() Regards, Rajesh. Nair -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Re: Formula to add date
thanks again. Very helpful tips! On Jan 12, 10:19 pm, Manoj kumar manoj.vishwakarma...@gmail.com wrote: Hello Guys, Fill Handle(the small black square on the bottom-right corner of a selected range of cells) is one of the best option to fill dates, in fact you can fill Days, Weekdays, Months and Years as well. *Here is the option :- * Instead of dragging the Fill Handle while holding down the left mouse button, try it by dragging with the right mouse button. When you release the mouse button, a menu will pop up giving you a list of fill options. If you need to add a range of dates 2 weeks apart on your sheet. Enter a starting date in the first cell, then right-drag the Fill Handle for how many dates you want. Click Series, type 14 in the 'Step value' box and click OK. If you want a series of dates for the 15th of each month. Enter a starting date, right-drag the Fill Handle for how many dates you want. Click 'Fill months' and click OK. Regards, Manoj Kumar On Thu, Jan 13, 2011 at 11:15 AM, mohan krishnan ayalur678...@gmail.comwrote: DEAR FRIEND, PLEASE TYPE 1/1/11 2/1/11 THEN TAKE BOTH COLUMN IN RANGE AND DRAG On Thu, Jan 13, 2011 at 7:34 AM, J D springer...@gmail.com wrote: I am no whiz kid with Excel but use it all the time. I usually just put a date in a cell drop to the next one and add 1. A1 would be the date formated how I want, A2 would be =A1+1. I then copy and paste that down the column or acroos a row. I have one spreadsheet that covers the year. I just use a simple =A()+1 and then click on the last date from the previous sheet. Not real high tech and because the months have different #'s of days there is a little fiddling around to make it how you want it but it works pretty easily. I am sure there is some better way to do it, but that is the thing about excel, the more I learn, the more I realize how little I know. On Jan 12, 12:20 am, Susan susan.m.ander...@comcast.net wrote: Hi, I'm looking for a formula that will add all dates of the month. It will auto-populate for me the next day in the month. Column A 01/01/2011 01/02/2011 01/03/2011 Etc, etc I am creating templates at work that all 12 templates need dates according to the month for column A: 01/01/2011 to 01/31/2011. Instead of manually typing all of the dates in column A1 to A31. Is there a formula to put in column A1 that will start with 01/01/2011 and I drag it down to finish at 01/31/2011. I tried =DATE(year,month,day)+1. It didn't work. Thanks much! ~Susan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Mohan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Extract data between two dates
See if this helps you out... Regards, Manoj Kumar On Thu, Jan 13, 2011 at 8:58 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Kalyan, Attached file has been solved per your requirement(s). :) Let me know if this works. Best Regards, DILIPandey On Thu, Jan 13, 2011 at 7:11 PM, Kal xcel kalx...@gmail.com wrote: Dear experts, Please help me on my quary. I have date wise depot wise product wise sale amount. I need to extract sale between two dates matching with other two criteria(Depot Product). I have tried sumifs sumproduct formula, but result is not coming properly. Please help Thanks in advance Kalyan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks Regards, DILIP KUMAR PANDEY, mvp MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Extract data between two dates_Manoj.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Offset Range Copy
try this Sub test() Dim i As Long ' change value of i as per your requirement i = 2 Range(ActiveCell, ActiveCell.Offset(i, 200)).Copy End Sub On Thu, Jan 13, 2011 at 11:03 PM, iggy-mac iggy-...@telinco.co.uk wrote: Ashish, Thanks for your help, that works just fine. If I was to take that a step further, how would I amend the code so that the copy range stepped 200 to the right, regardless of how many rows I highlighted ie sometimes I'll copy one row, somestimes it may be 2,3..4 rows. I can do it one at a time but if I can copy in one go, even better. Thanks in advance -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Formula of the week - share your best formula
hi 1 case sensitive lookup using index and match 2 vlookup indirect function Check the attachment. Given you the situations where I used them in the past On Thu, Jan 13, 2011 at 11:15 PM, Ms-Exl-Learner . ms.exl.lear...@gmail.com wrote: Hi All, I suggest all of you don't say this function I like and then this one like that. Just sharing the function name won't help others to gain some knowledge. All the functions which is available in excel is having the same set of qualities unless it is used in perfect combination. So give brief about the function and its different type of usages which you came across in your past. Hope this makes sense. --- Ms.Exl.Learner --- -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel sample.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ IF two criteria then count occurrences of TRUE
Hi, see attachment hope it may help thanks Regards ROHAN 9818247278, 8860567680 On Thu, Jan 13, 2011 at 8:51 PM, ashish koul koul.ash...@gmail.com wrote: attachement missing On Thu, Jan 13, 2011 at 7:11 PM, mikeb mb...@allstate.com wrote: I would appreciate some help with the following. I am trying to use two criteria and if they are true then count the occurrences of the work “TRUE” in a specified column, I have attached a sample worksheet using excel formulas; however I would not object to using VBA to accomplish the task. I actually have many different types of tests to do, I am only showing one; if we can solve this I will just extrapolate for the other tests. Any help will be greatly appreciated. Thank you, MikeB -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Result Occurance.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Formula of the week - share your best formula
One of the function which I do like is TRANSPOSE function. - This function copies data from a range, and places in it in a new range, turning it so that the data originally in columns is now in rows, and the data originally in rows is in columns. - The transpose range must be the same size as the original range. - The function needs to be entered as an array formula. - To enter an array formula you must first highlight all the cells where the formula is required. Next type the formula, such as *=TRANSPOSE(A1:A5)* and Finally press *Ctrl+Shift+Enter* to confirm it. If changes need to be made to the formula, the entire array has to be highlighted, the edits can then be made and the Ctrl+Shift+Enter used to confirm it. *Syntax :-* *=TRANSPOSE(Range)* Regards, Manoj Kumar On Thu, Jan 13, 2011 at 11:15 PM, Ms-Exl-Learner . ms.exl.lear...@gmail.com wrote: Hi All, I suggest all of you don't say this function I like and then this one like that. Just sharing the function name won't help others to gain some knowledge. All the functions which is available in excel is having the same set of qualities unless it is used in perfect combination. So give brief about the function and its different type of usages which you came across in your past. Hope this makes sense. --- Ms.Exl.Learner --- -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel TRANSPOSE FUNCTION_Manoj.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Our NEW Microsoft MVP - Dilip Kumar Pandey
Congratulations Dilip... :) Regds, Manish Pansari On Jan 5, 7:19 pm, Kal xcel kalx...@gmail.com wrote: Hi Dilip, Many many congratulation to you. This group needs you. Keep it up. On Wed, Jan 5, 2011 at 4:45 PM, SUMIT VYAS svyas0...@gmail.com wrote: Dear Mr. Dilip *Congratulations to you* Regards Sumit Vyas On Mon, Jan 3, 2011 at 3:31 PM, Ayush jainayus...@gmail.com wrote: Dear Group, I am very very very very happy to share a good news with you. One of our dearest group member Dilip Kumar Pandey is awarded Microsoft MVP award on 1st January for his exceptional Excel skills and voluntary contribution. He is well deserving for the award and I am very happy about his recognition. Dear Dilip, Many Many congratulations, Keep it up. I am very proud of you to be part of this group. I wish your long association with this group. Best Regards, Ayush Jain Microsoft MVP-2010 -- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall;... -- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall...- Hide quoted text - - Show quoted text - -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Fwd: HAPPY MAKARSANKRANTI
Thanks and Wish you* Happy Makar Sankranti* to u as well Regards, Manoj Kumar On Fri, Jan 14, 2011 at 10:55 AM, Chandra Singh Bora chandu...@gmail.comwrote: * आपको * * और * * आपके * * परिवार * *को * * मकर * *संक्रांति की ढ़ेर सारी शुभकामनायें* -- Chandra Singh Bohra Champawat Uttrakhand 09717336333 chandu...@gmail.com chandu...@rediffmail.com chandu.u...@yahoo.co.in -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Concatenate Value Problem
Dear Group Friends, I have two work sheet. Sheet1 contain bill number in column B, and sheet2 contain bill number and PRA No in column A and column B. My problem is, I want to concatenate the PRA No. with , for every unique bill Number. e.g. Sheet1 date are as Under: Bill No. FDN/01 FDN/02 FDN/03 FDN/04 Sheet2 data: Bill No.PRA No. FDN/01 M-01 FDN/03 M-02 FDN/02 M-03 FDN/04 M-04 FDN/01 M-05 FDN/02 M-06 FDN/01 M-07 FDN/04 M-08 FDN/02 M-09 FDN/03 M-10 Result required in Sheet1 Bill No.PRA Nos. FDN/01 M-01, M-05, M-07 FDN/02 M-03, M-06, M-09 FDN/03 M-02, M-10 FDN/04 M-04, M-08 I know the concatenate formula. but for that i have to apply it manually. Please assist me, how can i make it automatic. When I entered new PRA No. in sheet2, Sheet1 PRA Nos. get automatically update. Thanks for your regular help and suggestion. Regds, Manish Pansari -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ how to use Or in pivote table ?
I have a pivot table how to use Or in two columns I want to view all rows which Column1 = cat Or column2 = cat Not Column1 = cat AND column2 = cat By code or any way Thanks! -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Fwd: HAPPY MAKARSANKRANTI
धन्यवाद आप सब को भी मकर संक्रांति की शुभ कामनाये विकास गुप्ता On Fri, Jan 14, 2011 at 10:55 AM, Chandra Singh Bora chandu...@gmail.comwrote: * आपको * * और * * आपके * * परिवार * *को * * मकर * *संक्रांति की ढ़ेर सारी शुभकामनायें* -- Chandra Singh Bohra Champawat Uttrakhand 09717336333 chandu...@gmail.com chandu...@rediffmail.com chandu.u...@yahoo.co.in -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Re: how to remove the symbol of drop down list
Hi, i got it, in the tab homefind selectselection panehide all or as you want thanks regards ROHAN 9818247278, 8860567680 On Fri, Jan 14, 2011 at 12:14 PM, Rohan Young rohan.j...@gmail.com wrote: Hi, see the attachement for my prob., i made a drop down but after removing the list the symbol of dropdown list still is there, it is by default of any trick to remove, it is not coming in print but visible on screen please help Thanks Regards ROHAN 9818247278, 8860567680 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel