Re: $$Excel-Macros$$ Align cells with same value - vba almost working - please help

2011-03-12 Thread bpascal123
Tell me please how can an excel formula add rows ? -- -- 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://

Re: $$Excel-Macros$$ Align cells with same value - vba almost working - please help

2011-03-12 Thread rajan verma
use this in Column C:C =IFERROR(VLOOKUP(A1,B:B,1,0),"") Rajan. On Sat, Mar 12, 2011 at 3:42 PM, Sanjoy Nath wrote: > no need to write macro > sort any one column > and use lookup to other column > that will work fine > > > > On Sat, Mar 12, 2011 at 6:06 AM, bpascal123 wrote: > >> Hi cyberspace,

Re: $$Excel-Macros$$ Align cells with same value - vba almost working - please help

2011-03-12 Thread Sanjoy Nath
no need to write macro sort any one column and use lookup to other column that will work fine On Sat, Mar 12, 2011 at 6:06 AM, bpascal123 wrote: > Hi cyberspace, > > I have spent quite some time trying to make this work but at this > point from adding many msgbox checks, using the watch window