Hi All No boss this is also not working see i show you what excatly i want
202.718 198.724 200.178 202.867 195.514 Total 1000.000 this is i want that random unique numbers between 195.001 to 203.999 which always gives a total of 1000.000 after every total of 5 numbers Help me guyssssssssssssssssssssssssssssssss cheers!!! On Sun, Jul 3, 2011 at 12:40 PM, Rajan_Verma <rajanverma1...@gmail.com>wrote: > *See if it help* > > http://www.mrexcel.com/tip069.shtml**** > > ** ** > > * * > > * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *karunanithi ramaswamy > *Sent:* Saturday, July 02, 2011 9:29 PM > > *To:* excel-macros@googlegroups.com > *Subject:* RE: $$Excel-Macros$$ Urgent Help required!!!!!!!!!!**** > > ** ** > > Sir, > Do u have any idea of auto filling magic squre for a particular sum > total. Iam interested > to know it. Thanks if u could help. > -R.Karunanithi > > --- On *Sat, 7/2/11, Rajan_Verma <rajanverma1...@gmail.com>* wrote:**** > > > From: Rajan_Verma <rajanverma1...@gmail.com> > Subject: RE: $$Excel-Macros$$ Urgent Help required!!!!!!!!!! > To: excel-macros@googlegroups.com > Date: Saturday, July 2, 2011, 8:25 PM**** > > *See if it helps***** > > * ***** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Anshul Gupta > *Sent:* Saturday, July 02, 2011 7:39 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Urgent Help required!!!!!!!!!!**** > > **** > > Hi All. > > As m working in a import house for that i have to sales bills on daily > basis i just want a help that makes me easy to make that > > If someone tell that how to make 5 random numbers selection between 197.001 > to 203.999 which gives the total of 1000.000 > > Please help meurgent guys > > Cheers!!!! **** > > -- > > ---------------------------------------------------------------------------------- > 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**** > > -- > > ---------------------------------------------------------------------------------- > 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
