Freinds, In the querry worksheet, the data was in b3 and c3 and result is generated from e3 and f3 , but in actual, my data is available in column J222 and k222 in sheet named "kundali" , and i tried to change the range in Macro but failed. Hence, please send me the details as to where i should change the macro to generate result in L222 and M222. Is there solution by way of formula? If i am doing text to column>space>finish, the data from original column is lost and transferred to next columns. But i want the data to remain in original form and result in verticle form, Please do needful.
On Oct 10, 12:10 pm, Nemi Gandhi <nemigan...@gmail.com> wrote: > Thanks excel macro freinds. > > Nemi Gandhi > > On Oct 8, 8:46 pm, ashish koul <koul.ash...@gmail.com> wrote: > > > > > > > > > check the attachment > > > On Sat, Oct 8, 2011 at 3:07 PM, Nemi Gandhi <nemigan...@gmail.com> wrote: > > > Plaease provide solution. > > > > -- > > > Nemi Gandhi > > > 98204 92963 > > > > -- > > > > ---------------------------------------------------------------------------------- > > > 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 > > > -- > > *Regards* > > * * > > *Ashish Koul* > > *http://www.excelvbamacros.com/* > > > P Before printing, think about the environment. > > > querry ncg.xlsm > > 20KViewDownload -- ---------------------------------------------------------------------------------- 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
