Hi, for several weeks all the links to further details have not been working on any devices with which I'm connecting to this excellent group. Like more...
Please let me know what I need to do to make it work again. Regards Jørgen Bugge On Nov 7, 2011 11:34 PM, <excel-macros@googlegroups.com> wrote: > Today's Topic Summary > > Group: http://groups.google.com/group/excel-macros/topics > > - Calculate End of the Month and than lock in that date in a > cell<#1338061bf7590c7c_group_thread_0>[11 Updates] > - NEED ROWS HIGHLIGHT - REG <#1338061bf7590c7c_group_thread_1> [5 > Updates] > - Help me <#1338061bf7590c7c_group_thread_2> [7 Updates] > - Need help with screen tip <#1338061bf7590c7c_group_thread_3> [3 > Updates] > - Indian formats <#1338061bf7590c7c_group_thread_4> [4 Updates] > - Excel BUG! <#1338061bf7590c7c_group_thread_5> [2 Updates] > - possibility of form creation in msaccess 2003 like excel > vba<#1338061bf7590c7c_group_thread_6>[1 Update] > - Interact with other applications <#1338061bf7590c7c_group_thread_7>[1 > Update] > - How to use Advance filter <#1338061bf7590c7c_group_thread_8> [1 > Update] > > Calculate End of the Month and than lock in that date in a > cell<http://groups.google.com/group/excel-macros/t/5dc34f82b970494> > > Dave <davidstev...@gmail.com> Nov 07 10:21AM -0800 > > Hi experts, > > I have a spreadsheet in which employees record their daily work > inventory. I have 12 sections for each month. > I calculate the end of the month for each month by using the formula > ...more > > > Sam Mathai Chacko <samde...@gmail.com> Nov 07 11:56PM +0530 > > Yes, would give more perspective with a sample workbook. > > But from what one can make out, instead of having it to stop from > changing, > wouldn't it be better to have the calculation to encapsulate ...more > > > "dguillett1" <dguille...@gmail.com> Nov 07 12:31PM -0600 > > This should be easily doable. If desired, send forward this msg to > dguillett1 @gmail.com and attach your file. > > > > Don Guillett > SalesAid Software > dguille...@gmail.com > -----Original ...more > > > "dguillett1" <dguille...@gmail.com> Nov 07 02:13PM -0600 > > Assuming you DO have the analysis toolpak installed or can otherwise > use the > EOMONTH function, then this will do copied into each moth end block > where > a8, a29, etc. has the month spelled out. ...more > > > Sam Mathai Chacko <samde...@gmail.com> Nov 08 02:04AM +0530 > > If you plan to share this file among other members or across computers, > would recommend using an original first party formula to be on the > safer > side, than run a risk with the EOMONTH formula that ...more > > > Dave <davidstev...@gmail.com> Nov 07 12:51PM -0800 > > Yes its going to be shared.! > > > > ...more > > > Dave <davidstev...@gmail.com> Nov 07 01:03PM -0800 > > Thanks brilliant!! > > ...more > > > Dave <davidstev...@gmail.com> Nov 07 01:03PM -0800 > > Thanks brilliant!! > I just dont know how you guys ca figure this out so fast.!! > > > ...more > > > Sam Mathai Chacko <samde...@gmail.com> Nov 08 02:40AM +0530 > > Well, we try to fast enough! Anyway, on second thought, you could make > it > even simpler with this * > > *=DATE($P$1,MONTH("1-"&$A8)+1,0) > > Regards > > Sam Mathai Chacko > > > -- > Sam Mathai Chacko > ...more > > > Sam Mathai Chacko <samde...@gmail.com> Nov 08 02:41AM +0530 > > Well, we try to be fast enough! Anyway, on second thought, you could > make > it even simpler with this * > > *=DATE($P$1,MONTH("1-"&$A8)+1, > 0) > > Regards > > Sam Mathai Chacko > > > > -- ...more > > > "dguillett1" <dguille...@gmail.com> Nov 07 03:14PM -0600 > > If, as you say, it will be shared, use Sams > > > > Don Guillett > SalesAid Software > dguille...@gmail.com > -----Original Message----- > From: Dave > Sent: Monday, November 07, 2011 3:03 PM ...more > > NEED ROWS HIGHLIGHT - > REG<http://groups.google.com/group/excel-macros/t/abbe7004cd0dced1> > > jmothilal <gjmothi...@gmail.com> Nov 07 03:35PM +0530 > > Dear Friend , > > how is row highlighted explain please > > Mothilal.J > > > -- > J.Mohilal > Universal Computer Systems > # 16, Brindavan Complex > Otteri, Vellore-2 > ...more > > > "dguillett1" <dguille...@gmail.com> Nov 07 07:22AM -0600 > > You did NOT say if Sam guessed what you wanted. As he said, he used > conditional formatting. > Prior to xl2007, select the cell that is colored>format>conditional > formatting> > to see the formula he ...more > > > jmothilal <gjmothi...@gmail.com> Nov 07 07:23PM +0530 > > Thank u once again > > > -- > J.Mohilal > Universal Computer Systems > # 16, Brindavan Complex > Otteri, Vellore-2 > ...more > > > "dguillett1" <dguille...@gmail.com> Nov 07 08:22AM -0600 > > You did NOT say if Sam guessed what you wanted. > > Don Guillett > SalesAid Software > dguille...@gmail.com > > From: jmothilal > Sent: Monday, November 07, 2011 7:53 AM ...more > > > Sam Mathai Chacko <samde...@gmail.com> Nov 07 10:40AM -0800 > > So in the conditional format for the first sheet 1563, I have selected > the range A9:F99, and put the conditional in the 'Format values where > the formula is true' section as =$G9<30 > ...more > > Help me <http://groups.google.com/group/excel-macros/t/8c4343a39e506256> > > vijayajith VA <vijayajith...@gmail.com> Nov 07 08:47PM +0530 > > Hi > > Thank you Very much for your help. > > If i run this macros.Some error is showing like VA_book1.xls is not > found > error 1004 > > i have saved correctly in my folder i run the macros but its not > ...more > > > "dguillett1" <dguille...@gmail.com> Nov 07 09:23AM -0600 > > Are both files in the same folder? Is the source file named VA_ > book1.xls or book1.xls ? > > Don Guillett > SalesAid Software > dguille...@gmail.com > > From: vijayajith VA > Sent: Monday, November 07, ...more > > > vijayajith VA <vijayajith...@gmail.com> Nov 07 09:05PM +0530 > > Hi Don Guillett, > > Once again thank you very much . > I those two excelbooks saved one folder and named as VA_book1.xls - > (one > file -blank file) > and one more file saved as VA_book2.xls .i pasted ...more > > > "dguillett1" <dguille...@gmail.com> Nov 07 09:53AM -0600 > > On the samples you sent to me you said that you wanted to fill in > blanks in book2 from data in book1. So, the macro works when placed in a > module in book2 and executed from book2 > > ...more > > > vijayajith VA <vijayajith...@gmail.com> Nov 07 09:58PM +0530 > > Hi > > Ya exactly correct i want to fill those blanks.but coding is not > working i > dont knw the reason.please chk below screen shot > > > [image: image.png] > > ...more > > > "dguillett1" <dguille...@gmail.com> Nov 07 11:21AM -0600 > > What is the drive and name of your folder. c:\test > > Your screenshot shows you my macro in my VA_book2.xls. If you have > VA_book1.xls in the same folder,it should find it. > Both of your sample files ...more > > > "dguillett1" <dguille...@gmail.com> Nov 07 11:28AM -0600 > > Maybe you need to fully identify your folder such as > > Workbooks.Open Filename:="c:\yourfolernamehers\VA_book1.xls" > > > Don Guillett > SalesAid Software > dguille...@gmail.com > > From: vijayajith VA ...more > > Need help with screen > tip<http://groups.google.com/group/excel-macros/t/8d6c1786a654ec24> > > krishnanm2...@gmail.com Nov 06 06:21PM > > All - I need some help with screen tips... Basically I have a jpg > image in excel and all I want to do is to display some numbers at specific > places with my mouse movement... And I do not want a ...more > > > krishnanm2...@gmail.com Nov 07 03:32AM > > All is there a resolution for this?? > > Krishnan > Sent on my BlackBerryŽ from Vodafone > > -----Original Message----- > From: krishnanm2...@gmail.com > Date: Sun, 6 Nov 2011 18:21:31 ...more > > > Sam Mathai Chacko <samde...@gmail.com> Nov 07 09:00PM +0530 > > You can use hyperlinks with custom screen tips in small shapes placed > on > top of your actual image, and make those shapes transparent. > > Regards, > > Sam Mathai Chacko > > > -- > Sam Mathai Chacko > ...more > > Indian > formats<http://groups.google.com/group/excel-macros/t/6ee6e9083b1687d4> > > jmothilal <gjmothi...@gmail.com> Nov 07 03:41PM +0530 > > Dear Friend > > when i try 2 this #\,##\,##\,###.00 format i get it following, > > [image: image.png] > > > -- > J.Mohilal > Universal Computer Systems > # 16, Brindavan Complex > Otteri, Vellore-2 > ...more > > > Sam Mathai Chacko <samde...@gmail.com> Nov 07 08:27PM +0530 > > With a little search you can chance up on this site > > > > http://www.yogeshguptaonline.com/2009/10/excel-number-format-indian-style-comma.html > > Regards, > Sam > > > -- > Sam Mathai Chacko > ...more > > > Sam Mathai Chacko <samde...@gmail.com> Nov 07 08:28PM +0530 > > With a little search, you can chance up on this site > > > > http://www.yogeshguptaonline.com/2009/10/excel-number-format-indian-style-comma.html > > Regards, > > Sam Mathai Chacko > > > -- ...more > > > Sam Mathai Chacko <samde...@gmail.com> Nov 07 08:28PM +0530 > > With a little modification, you can chance up on this site > > > > http://www.yogeshguptaonline.com/2009/10/excel-number-format-indian-style-comma.html > > Regards, > > Sam Mathai Chacko > > > -- ...more > > Excel BUG!<http://groups.google.com/group/excel-macros/t/e48300247c393b8c> > > Asto <astolfi.marco...@gmail.com> Nov 07 02:19AM -0800 > > Dears, > let me say that something is going wrong: > > - put in cell A1 the number 1 > - type in another cell =A1^2 --> the results it's 1. well... > - type in another cell = - A1^2 --> the results ...more > > > Sam Mathai Chacko <samde...@gmail.com> Nov 07 08:06PM +0530 > > Asto, > > 1 powered by any whole number is 1 (well, logically YEAH!) > -ve number powered by an even number will be positive (nothing more > logical > than that!) > Zero minus one will be minus one (wonder ...more > > possibility of form creation in msaccess 2003 like excel > vba<http://groups.google.com/group/excel-macros/t/19bc640e3c23dd16> > > Shankar Bheema <shankar.n...@gmail.com> Nov 07 04:49PM +0530 > > I am presenting my excel VBA form below and also as an attachment of > the > screenshot. > > http://i40.tinypic.com/wa3ekl.jpg > > With the help of all of this forum I created and simplified my work at > ...more > > Interact with other > applications<http://groups.google.com/group/excel-macros/t/3a02da48a8cf3f57> > > Rohan <bittu.ro...@gmail.com> Nov 06 10:38PM -0800 > > Hi Guys, > > Thanks for your continued efforts to keep this group running, its very > helpful and a great knowledge sharing resource. > > I wanted to know, how do we go ahead about making office ...more > > How to use Advance > filter<http://groups.google.com/group/excel-macros/t/fac557c205d2168f> > > Rohan <bittu.ro...@gmail.com> Nov 06 10:02PM -0800 > > Hi, > The link that's provided is very good. Just checked it out, in see > nearly all the info there. > If you have not tried this link, please have a look and it should > solve all your queries about' ...more > > You received this message because you are subscribed to the Google Group > excel-macros. > You can post via email <excel-macros@googlegroups.com>. > To unsubscribe from this group, > send<excel-macros+unsubscr...@googlegroups.com>an empty message. > For more options, > visit<http://groups.google.com/group/excel-macros/topics>this group. > > -- > FORUM RULES (925+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
