Hi Anshul, As per the latest scenario provided by you, attached solution may help you. Let me know if this works :)
Regards, DILIPandey On 7/4/11, Anshul Gupta <thatsme.a...@gmail.com> wrote: > 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 > -- Thanks & Regards, DILIP KUMAR PANDEY, mvp MBA,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
RandNo. Genie - by DILIPandey.xls
Description: MS-Excel spreadsheet