Re: $$Excel-Macros$$ HOW TO CONVERT DATE IN TEXT WITH FOMULA
In cell F5 try the following formula: =CHOOSE(MONTH(E5),January,February,March,April,May, June,July,August,September,October,November,December) On Wed, Feb 2, 2011 at 2:39 AM, solomon raju faithful1...@gmail.com wrote: Hi All, How can we extract month in text. Can someone define some formula for this. Attached my question in clear. Regards, Solomon -- -- 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 Correction
Jay Try putting the following formula in cell C3: =LEFT(B3,FIND( ,B3,1)) Norman On Wed, Aug 25, 2010 at 4:56 AM, lucky singh lucky60...@gmail.com wrote: Hi, Need help in formula... I just need the only the first name to be extracted without space or gap... Regards, Jay S 8108932708 -- -- 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 HELP US GROW !! We reach over 7000 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. 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 HELP US GROW !! We reach over 7000 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$$ purchase order number
Colvert, Try downloading P O Master from the following link: http://www.scribd.com/doc/5443728/PO-Master-06-25-09 You will have to be a member to download. Membership is free. Norman On Mon, Mar 22, 2010 at 5:05 PM, lecolvert lecolv...@gmail.com wrote: Good Morning all, I want to create a macro that can generate purchase order number automatically after the last saving. Thanks for your help Colvert Port-au-Prince,Haiti -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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 To unsubscribe from this group, send email to excel-macros+ unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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 To unsubscribe from this group, send email to excel-macros+unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject.
Re: $$Excel-Macros$$ Excel Formula Required
Try the following attached file This is a left lookup On Thu, Mar 18, 2010 at 5:01 AM, Venkatesan c venkat1@gmail.com wrote: Dear All, Any one can Assist me attached file query It's something like reverse Lookup -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 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 HELP US GROW !! We reach over 6,800 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 Query(2).xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Excel Accounting
The following might be helpful: http://www.scribd.com/doc/5401866/Account-Register-12-10-09 To download this document you will have to become a member, but it's free. Use the filters to get desired totals. Norman On Tue, Jan 26, 2010 at 1:45 AM, Robinson Boreh rbo...@gmail.com wrote: Hi guys, I am doing some financials of a small company with less than 50 transaction per year. Well it's very small and I don't think I have to buy a fully functioning accounting software, it will not be worth it. I am therefore turning for your help in this regard. Is there someone who has developed any excel that can sort me out with this. I have tried making a spreadsheet with the cash book as the main sheet. Whenever I update the cashbook, then I ought to effect the transaction in respective income, expenses, liability or asset account. The problem is automation..how could I automate so that if I enter a code for the transaction, it automatically posts in the correct account and also for the entries to be in sequential manner. I need your help guys. Regards *Robinson Boreh, * *Finance Department, Upper Hill,* *Tel: 2874243, 0711019243 Fax: 2719705* *“Experience is what you get, if you don’t get what you actually wanted.”* -- -- 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$$ how to keep cursor in current field after enter.
In Excel 2003 go to Tools/Options/Edit then remove the check mark from Move selection after enter. Norman On Mon, Jan 25, 2010 at 6:38 PM, Wilbur Kush ocwil...@gmail.com wrote: I have a scale that inputs data into excel via rskey, a keyboard emulator that comes with the scale. No problems getting the data into excel from the scale, however, a carriage return (enter) is sent after the weight is entered into field A1. This sends the cursor to A2 after entering the weight into A1. I am trying to get excel to move the cursor back to A1 after the carriage return so I can update the weight when needed. Can Excel be told to move the cursor to A1 when it arrives at A2 ? I am a total noobie to excel, so I apologize if I am not using the proper terms. I searched the forums to no avail. I think my lack of experience with excel's terms might be the problem. Everything else works great and I think if I can get this one issue resolved, It should work. Any input is appreciated. Wilbur -- -- 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$$ gauss jordan method
This might help you: http://people.hofstra.edu/Stefan_Waner/RealWorld/Excel/tuts/ExcelPivot.xls Norman On Mon, Jan 11, 2010 at 4:15 PM, larry laurence.tha...@navy.mil wrote: I am trying to use the Gauss/Jordan method as a subrouting in my code. This is code that lets you put linear equations into a matrix and then finds the values for the variables in the equations. I am concerned that my rewrite has made the count off so I am not getting the answers I expect. Can anybody tell me if I am missing a step? Thanks Sub Jordan(N, M, A) For K = 1 To N For J = (K + 1) To M A(K, J) = A(K, J) / A(K, K) Next J For I = 1 To N If I K Then For J = (K + 1) To M A(I, J) = A(I, J) - A(I, K) * A(K, J) Next J End If Next I Next K -- -- 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 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
Re: $$Excel-Macros$$ Help for if...match formula
Try the following formula in cell C11 =IF(ISNA(VLOOKUP(A11,E2:F6,2,0)),Not Found,VLOOKUP(A11,E2:F6,2,FALSE)) On Sun, Nov 29, 2009 at 10:15 AM, mahesh parab mahes...@gmail.com wrote: Dear All In attach sheet i want to find matching text from another column, Can anyone help for formula.below mention formula is not working.i will appreciate any help on this =IF(MATCH(*A2*,E1:F4,0),OFFSET(E1,1,1),Not Found) Thanks, -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@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. Our goal is to have 10,000 subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@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. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Date format problem
Jitesh Try formatting the cells as TEXT Norman On Fri, Nov 27, 2009 at 5:40 AM, Jitheesh Vazhapully 7jit...@gmail.comwrote: Good Evening Excel Gurus, I have a data in this format 01-01-01, however as soon as I enter them in the excel sheet,excel picks it up as date and stores it in date format, Is there any way I can prevent this from happening. Also how to convert this data back from date format 01/01/2001 to original 01-01-01 format Thanks Regards Jitesh -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@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. Our goal is to have 10,000 subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@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. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ unable to set the visible property of the worksheet class
The workbook is protected with a password. Norman May On Thu, Nov 12, 2009 at 11:09 AM, mahesh parab mahes...@gmail.com wrote: Dear All In attach sheet when i try to unhide sheet i am getting caption error. steps are mention on below mention link http://www.ehow.com/how_2132122_worksheet-another-user-cant-unhide.html In visual basic screen when i click on the sheet try to make visible in properties window. i am getting caption error.Anyone knw how to unhide worksheet through visual basic -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@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. Our goal is to have 10,000 subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@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. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: Need a function or formula
Pooja, Try the following formula in cell D6, then copy down: =IF(ISERROR(FIND(e,B6)),,RIGHT(B6,((LEN(B6))-(FIND(e,B6)))+1)) Norman On Sat, Oct 31, 2009 at 10:55 AM, Pooja Sharma vatspoojav...@gmail.comwrote: Hi All, I need your help in extracting some words (having defined format) from one cell in another cell. Attached is a sheet where I have mentioned the case and the solution I require. Hope you will help me. Best Regards Pooja Sharma *** --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@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. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: excel does not recognize dates
Try looking at the DATEVALUE function in Excel. On Fri, Oct 30, 2009 at 8:00 AM, manni...@nationwide.com manni...@nationwide.com wrote: I'm using a access macro to export access crosstab query results to excel. Everything works great, except that the column names are dates that export to excel as text. Excel formulas do not recognize it as a date, and dependent formulas result in errors. Excel does not recognize them as a date until I enter the cell by double clicking on it (going to formatcells doesn't help). After exiting, the date appears in date format and can be recognized by excel formulas. I've seen this many times before and have never found a work around other than entering and exiting the individual cells. I posted this on microsoft.public.access and didn't find a solution. --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@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. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Count of Colored Cells
Pooja, Here is a couple of websites that accomplish this with a user defined function (UDF). http://www.exceltip.com/st/Count_by_color_using_VBA_in_Microsoft_Excel/518.html http://www.ozgrid.com/Excel/count-sum-cell-color.htm Norman On Tue, Sep 15, 2009 at 1:45 AM, Pooja Sharma vatspoojav...@gmail.comwrote: Hi Friends, I have a query regarding counting of Colored cells. I want to know, is it possible to count the no. of cells filled with a particular color with the help of a formula. If yes then please guide me and help me in resolving this. Attached is a file which has an example, how I want to count the cells. -- Best Regards Pooja Sharma --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@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. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Urgent_ Need ranking formula
Enter the following array formula in cell G14 then copy it down to G22: =RANK(E14,$E$14:$E$22,0)-SUM(IF(FREQUENCY($E$14:$E$22,$E$14:$E$22)0,0,1)*IF($E$14:$E$23E14,1,0)) This formula must be entered as an array formula using (Ctrl + Shift + Enter). This formula came from the website below: http://www.bettersolutions.com/excel/EUV214/YI216520881.htm Scroll down to Removing the Duplicates Norman On Wed, Sep 9, 2009 at 12:28 PM, vinod rao vinod.ma...@gmail.com wrote: Hello Team, Need ranking formula.See attached, kindly help. Regards --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@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. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Lookup Query
Enter the following formula in cell J7 and copy it down: =INDEX($C$6:$G$6,MATCH(I7,C7:G7,0)) Norman On Tue, Sep 8, 2009 at 2:46 AM, gyanesh jain gyanjai...@gmail.com wrote: Hi friends, I have some Query related with Lookup. its in attachment. can any provide the solution? -- Thanks, Gyanesh Jain, BE, MBA (Finance) +91 98868 68488 Please Save a tree...please don't print this e-mail unless you really need to --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@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. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: edit all sheets in a workbook at the same time?
You can select the first sheet tab, hold the shift key then select the last sheet tab. This will activate all sheets. Enter the desird content of the any cell On Mon, Sep 7, 2009 at 5:53 AM, rmullan mullanr...@hotmail.com wrote: Hi. I have been using Excel for years but never really needed to get into VBA too much .. usually recording the macro was sufficientbut now I am learning VBA as I go. I want to know if there is a command which will allow me to all sheets in a workbook at the same time. I want to enter text into cell A12 for all possible sheets. The number of sheets can change from time to time...otherwise I would just list them by name...tedious but effective. Any help would be appreciated --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Calculating renewal dates
Eric, If your Begin Date is in cell A2 and cell B2 has the Number of years. To calculate the Renewal Date try the following formula in cell C2: =A2+(B2*365.25) Begin DateYearsRenewal Date - 10/25/2005410/25/2009 Norman On Sat, Sep 5, 2009 at 3:04 PM, Eric ericc...@gmail.com wrote: I'm having a difficult time with something that sounds pretty simple on the surface but seems to get devilishly hard (at least for me) as I look further into it. I need to calculate contract renewal dates based on the original signing date. For a 1 year term it's pretty straight forward but for contracts that have a 2 year term the problem is more tricky. We also have a few contracts that have 3 and 5 year terms so I'd need a solution that is general and can be applied to any length contract term. Here are some examples of the dates I'd need be able to calculate: Contract term length: 2 years Begin Date Renewal Date -- 10/25/2005 10/25/2009 12/8/2003 12/8/2009 2/27/2004 2/27/2010 3/8/20043/8/2010 3/27/2002 3/27/2010 4/18/2006 4/18/2010 4/23/1998 4/23/2010 5/1/20065/1/2010 5/6/20045/6/2010 5/7/20045/7/2010 5/24/2006 5/24/2010 6/6/20026/6/2010 6/25/2004 6/25/2010 7/28/2004 7/28/2010 8/2/20028/2/2010 8/10/2006 8/10/2010 Any ideas or suggestions would be greatly appreciated. -Eric --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Advanced conditional formatting
Suresh, This might help you http://www.mrexcel.com/hof001.php Norman On Thu, Aug 27, 2009 at 7:21 AM, suresh k brave.sur...@gmail.com wrote: Hi Guyz, Whenever we use conditional formatting it will be applied for current cell only. Is there anyway that if the condition is true the entire row should be colored??? Regards, Suresh --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Application TimeValue
This might be helpful. http://www.cpearson.com/excel/TimedClose.htm Norman On Thu, Aug 27, 2009 at 7:50 AM, Jack j...@jackcwood.co.uk wrote: i need some vb to check if the time is greater than eg IF Application TimeValue (08:00:30) Then activeworkbook.close Any ideas Many thanks --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Add multiple comments
I'm not sure if this is what you want... Example: =The amount in cell A1 is A1 and this will change daily. On Tue, Aug 4, 2009 at 11:48 AM, Jaspal Rehal rehal.jas...@gmail.comwrote: Hi, I have to delete so many cell entries in my daily job and input those cell entries in the comments with some text. Any shortcut for the same would be helpful ... Rg --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: URGENT HELP
Rajesh, Try the formula below: =INDEX(B1:B12,MATCH(9.99E+307,B1:B12)) Norman On Mon, Aug 3, 2009 at 1:01 AM, Rajesh Janardanan rajesh...@gmail.comwrote: Dear All, Need an urgent help , please refer the attached file , I need a formula which will read YTD (B13) as the last cell entered , in the attached file B9. If I update the file for september B13 automatically should pick from B10. Please advise Best regards Rajesh --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Template Development
A Hakim, I have an invoice workbook at the website below, it might be helpful. http://sites.google.com/site/normay/excel-files Norman On Thu, Jul 30, 2009 at 10:53 AM, Abdul Hakim Khan abdulhakimk...@gmail.com wrote: Dear All, I want to develop an excel template to automate invoicing jobs. The problem is as described. FROM Cell A10 To L10 Data is manually plugged. Based on this data Cell O10 have a formula that automaticall describe the manually entered Cell description. Based on formulae O10 the unit price auto entered in M10. Cell M10 has array formula and value returned is stored some where else ?? Formulla in M10 : =SUM(IF('C:\PRG\[Insuprg.xlsx]InsuPrg'!$G$8:$G$4002=ENTRYSHT!O10,'C:\PRG\[Insuprg.xlsx]InsuPrg'!$H$8:$H$4002,0)) Formulla in O10 : IF(F10=Remove Cladding,CONCATENATE(F10,I10,J10),IF(F10=Remove Insulation,CONCATENATE(F10,I10,J10),IF(F10=Reinstall Insulation,CONCATENATE(F10,I10,J10),IF(F10=Reinstall Cladding,CONCATENATE(F10,I10,J10),IF(F10=New Insulation,CONCATENATE(F10,G10,I10,J10,K10),IF(I10=PIPE,CONCATENATE(F10,H10,I10,J10,K10),CONCATENATE(F10,G10,H10,I10,EVEN(K10*2/25.4+J10 I want to develop an excel template for above said problem and the formula as UDF in Template. Please assist ? Help is deeply welcome ? Rgds, A Hakim --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: DateStamp Macro Debug Help
This modified code seems to work Public Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 1 Then 'Application.EnableEvents = False On Error GoTo Errorhandler Target.Offset.Offset(0, 13) = Now() 'Application.EnableEvents = True End If Errorhandler: End Sub Norman On Fri, Jul 17, 2009 at 3:36 PM, Pogster pogs...@gmail.com wrote: Hey all, I found a very simple macro to track any changes made to any cell in a row by datestamping the end of the row. The issue comes in whenever i try to insert a row into the sheet, i get an error: Runtime Error 1004, Application-defined or Object- defined error and im not sure how to fix this. Here is a sample of my code: Public Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 1 Then Application.EnableEvents = False Target.Offset.Offset(0, 13) = Now() Application.EnableEvents = True End If End Sub Could anyone please point me in the right direction, how can i keep this functionality and still be able to insert new rows into my sheet? Thanks in advance! Best Regards, Pogster --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Required help on subtotal function.
Attached is a solution. Subtotal is not what you want to use. This is done with dynamic named ranges and data validation. Norman On Wed, Jul 15, 2009 at 6:07 AM, Rabindra Thapa rabinthapa2...@gmail.comwrote: Hello Guys, can somebody help me on attach file. -- Regards, Rabindra Thapa ¨`·.·´¨) Always `·.¸(¨`·.·´¨) Keep (¨`·.·´¨)¸.·´ Smiling! `·.¸.·´ (¨`·.·´¨) (¨`·.·´¨) `·.¸(¨`·.·´¨)¸.·´ `·.¸.·«*:·. .·:* *:·. *«*:·. .·:* *:·. --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- Help_on_subtotal_for_Text.(1).xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Need help to remove the * from cell entire row
Manoj, In the find and replace box precede the asterisk with a tilde. Example: ~* Norman On Wed, Jul 8, 2009 at 6:06 AM, Manoj S Negi manojsnegi.uttranc...@gmail.com wrote: Hi Friends, Please help meas my query is as follows... In the attached sheet in column there is some data and some cells are having * and I want to remove the * from the cells. Kindly look into this and advice ... Thanks for your support. Unfeigned Regards Manoj S Negi --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Simple Question - Search and Replace for Current Sheet Only in VBA
Is this segment of code in a looping macro that cycles through the entire workbook? Norman On Sun, Jul 5, 2009 at 10:54 PM, Norman May nor...@gmail.com wrote: Try this: ActiveSheet.Cells.Replace What:=1234, Replacement:=, LookAt:=xlWhole, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False Norman On Sun, Jul 5, 2009 at 9:14 PM, Ritland ritl...@gmail.com wrote: I know this must be a simple quesiton but I'm stumped. I wanted to do the following search within the active sheet only NOT the entire workbook. ' Cells.Replace What:=1234, Replacement:=, LookAt:=xlWhole, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False Right now it replaces 1234 across the entire workbook. Any ideas on how to limit it to the active sheet only? Thanks! --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Simple Question - Search and Replace for Current Sheet Only in VBA
Try this: ActiveSheet.Cells.Replace What:=1234, Replacement:=, LookAt:=xlWhole, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False Norman On Sun, Jul 5, 2009 at 9:14 PM, Ritland ritl...@gmail.com wrote: I know this must be a simple quesiton but I'm stumped. I wanted to do the following search within the active sheet only NOT the entire workbook. ' Cells.Replace What:=1234, Replacement:=, LookAt:=xlWhole, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False Right now it replaces 1234 across the entire workbook. Any ideas on how to limit it to the active sheet only? Thanks! --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Help Needed!!!!
Can you simply format the cells to SPECIAL then choose PHONE NUMBER? Norman On Tue, Jun 9, 2009 at 7:38 AM, amrahs k amrahs...@gmail.com wrote: Dear Harmeet and Team, I have attached a sample file for your reference with my simple query. Could you please look into this and advice me to proceed further. Thanx in Advance, Regards, Sharma --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Looking for a finance spreadsheet
There is an account register at: http://scribd.com/ncmay Norman On Sat, Jun 6, 2009 at 11:36 PM, Ashish Jain 26may.1...@gmail.com wrote: Hi Ryan, Did you tried templates on Microsoft website? Here is the link, plz reply with your feedback. http://office.microsoft.com/en-us/templates/CT101527321033.aspx?av=ZXL Here you'll find templates on Receipts Invoices Budget Inventories and Expense reports etc. - Regards Ashish Jain http://www.excelitems.com http://www.openexcel.com *Developer of Open XL* - On Jun 6, 11:51 am, spazlon spaz...@gmail.com wrote: Hello, I am looking for a personal finance spreadsheet. I tried making one of my own, but quickly realized I lacked the knowledge to do what I wanted. Basically I want to have one sheet that will have all of my transactions on it with a Debit and Credit column. I will also have a sheet for each of my accounts. When I add a transaction to my main sheet, I want it to reflect in the corresponding account sheets. For example, if I debit $100 from Checking and credit Savings, I want that row to appear on the Checking and Savings sheets as well. Does anybody have a sheet that will do this? Thanks! - Ryan --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Need help on syntax
Try the link below: http://www.ozgrid.com/News/excel-validation-tips.htm Norman On Thu, May 28, 2009 at 12:09 PM, Ahmet Yalcin ahmetyalc...@gmail.comwrote: Hello Paul, Thank you. What I am trying is to gather data from same address on many sheets in my workbook. The name of the file is 2008-04 BIL.xls and within I have sheets called KM, KS and KD (of course this is just a representative picture of a larger project). Can you kindly suggest what I should do? Also thank you for pointing out for starting with 0 declaring an array. Thanks again Ahmet 2009/5/28 Paul Schreiner schreiner_p...@att.net you're trying to insert the sheet name??? I assume the . . . is including code that is selecting a different cell. so the ActiveCell for loop x = 1 is different than the Active Cell when x = 3. try recording a macro. Also, keep in mind that when you declare an array, the indexes start at 0, not 1. so, Dim Company(3) has values in Company(0), Company(1) and Company(2). there IS no Company(3) Next + means to ADD two values. what you mean to do is to concatenate two strings using try: Sub test() Dim Company(4), x Company(1) = KM Company(2) = KS Company(3) = KD For x = 1 To 3 Cells(x, 1).Select ActiveCell.FormulaR1C1 = ='[2008-04 BIL.xls] Company(x) '!R7C4 Next x End Sub Paul -- *From:* Ahmet Yalcin ahmetyalc...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Thursday, May 28, 2009 10:19:08 AM *Subject:* $$Excel-Macros$$ Need help on syntax Hello, Please help me with the right syntax writing the below ActiveCell.FormulaR1C1 = ='[2008-04 BIL.xls]+Company(x)'!D7 line. I wish to insert the Sheet name as I did (Company(x) ) but keep on getting an error. Thank you in advance Regards Ahmet - Dim Company(3) Company(1) = KM Company(2) = KS Company(3) = KD For x= 1 to 3 . . . ActiveCell.FormulaR1C1 = ='[2008-04 BIL.xls]+Company(x)'!D7 . . . Next x --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Help need to write macro
The attached workbook will display the sum of column A in a message box whenever there is a change in column A. Norman On Fri, May 29, 2009 at 10:47 AM, Ramesh Katta kr.sap...@gmail.com wrote: Hi Gurus, I am Ramesh, new to vba programs. I need a macro to calculate sum for range of column. The should be displayed with MsgBox. For example: Column A has numbers 1,2,3,4,5,6,7,8,9,10... I want to calculate the cells we entered and displayed on MsgBox. ThanksRegards Ramesh --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~--- Sum ColA with VBA.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Need help on syntax
I'm not sure if this will work. Try replacing the + with Norman On Thu, May 28, 2009 at 10:19 AM, Ahmet Yalcin ahmetyalc...@gmail.comwrote: Hello, Please help me with the right syntax writing the below ActiveCell.FormulaR1C1 = ='[2008-04 BIL.xls]+Company(x)'!D7 line. I wish to insert the Sheet name as I did (Company(x) ) but keep on getting an error. Thank you in advance Regards Ahmet - Dim Company(3) Company(1) = KM Company(2) = KS Company(3) = KD For x= 1 to 3 . . . ActiveCell.FormulaR1C1 = ='[2008-04 BIL.xls]+Company(x)'!D7 . . . Next x --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: more than 3 rules in condtional formatting
Try the link below: http://www.mrexcel.com/archive/Formatting/12054.html Norman On Tue, May 19, 2009 at 1:50 PM, Balla kishore.maro...@gmail.com wrote: Hi, M using excel 2003, and say i need to have this below rule for a cell if value is india, background color blue if value is aus, background color yellow if value is sa, background color pink if value is eng, background color red if value is sl, background color navyblue m using conditional formatting, but it gives only 3 rules, is there any workaround for this Thanks Kishore --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Help required
If the exposure cell is A1, try the following formula: =IF(A1501,Urgent Action Required,IF(A1300,Action Required,No Action Required)) Norman On Fri, Apr 17, 2009 at 10:47 AM, healthandsafetysupp...@googlemail.com healthandsafetysupp...@googlemail.com wrote: Hi, Im a bit stuck on a worksheet. I am making a sound exposure sheet. At the end of the form I have a cell that has a number relating to exposure. What im trying to do is the a cell below, create a code, formula or som thing that would identify action required, i.e; If the exposure cell equals 150, i want a cell below to automatically say 'No Action Required' I have tried to do it as a criteria, i.e 300 No Action Required, 301: 500 Action Required, 501 Urgent Action Required. They are the messages I want to appear in the cell below when the exposure cell is completed. I have no idea about creating scripts etc, only basic sums. Any help would be really great! Many thanks, --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Concatenate Macro
Steve, You can do it with a simple formula if you want: If you have data in cell A2 and B2 you want to join, the following formula will work: =A2 B2 Then you can copy and paste special (Values) Norman On Mon, Apr 6, 2009 at 4:55 PM, Steve sspatri...@yahoo.com wrote: Hi, I could really use some help with creating a macro. I have two columns of data. The first column provides me with a list of Part Numbers and the second column Provides the Description of the Part Numbers. There are multiple rows for the Descriptions because that's the way they come into my spreadsheet. Looks something like the following: (Column A)(Column B) Part Number Description 100-100 Box with Cover and 4 slotted sides 100-211 Bubble Wrap, ESD sensitive 100-344 Shipping crate with pallet. I need the information in column B to be concatenated onto one line, preferably in the same row as the Part Numbers. Any help would be much appreciated. Thanks, Steve --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: SumIf function and custom view
Try using the Subtotal function. Norman On Thu, Apr 2, 2009 at 12:43 PM, Dave dk...@pro4ia.com wrote: I am currently using a SumIF function that works fine, hoever, I applied a series of custom views with filtered row items and the Totals remain the same (i.e., still grabing the data from the hidden rows. How do I combine these functions to have the SumIf totals to eqaul the subset of filtered data? thx in advance! --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: pivot table help
Ankur, Here is a link to an attendance sheet I made. I'm not sure it will do what you want. http://www.scribd.com/doc/6078466/Attendance-History-091708 Norman On Mon, Mar 30, 2009 at 2:42 PM, ankur lodha ankurlod...@hotmail.comwrote: hi everyone i've a task to prepare an attendance register of 10 candidates at my office.. i'm stuck in pivot table formation.. I'm attaching the sheet for your perusal.. I want name of candidates in rows.. present / leave / comp off / holiday being the column header and count of presents / leaves .. etc. pertaining to each in data field.. eg: presentleaveholiday comp off names count of each Please help.. ankur lodha -- So many new options, so little time. Windows Live Messenger.http://www.microsoft.com/india/windows/windowslive/messenger.aspx --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. 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 or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Excel Help
I'm not sure if his would help you? Download Personnel Timesheet 08-12-07.xls at http://normay.741.com/ Norman May On Sat, Jan 10, 2009 at 1:44 PM, How Do you? mydreambas...@hotmail.comwrote: I'm using excel to do weekly time sheet and I created another page/tab with in the same workbook and I'm trying to post job numbers between the two sheets. If I post a new Job number and it's not already on the control sheet I want to add, not + but include it in the job numbers. Anybody? --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~--~~~~--~~--~--~---