Dear Mr. Fabio Lemos,
I replaced ; with , and got the result. Thanks for this short formula. Please discard my previous e-mail for sample file. Thanks Regards, ZAFAR IQBAL From: Zafar Iqbal [mailto:ziqba...@gmail.com] Sent: Sunday, May 15, 2011 10:15 AM To: 'Fabio Lemos' Cc: 'excel-macros@googlegroups.com' Subject: $$Excel-Macros$$ Please help to make my project good. Dear Mr. Fabio Lemos, Thanks for your interest. I tried to apply your below mentioned formula. I am getting error message. Can you please send me sample file with formula. Thanks a lot for this kindness. Regards, ZAFAR IQBAL From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Fabio Lemos Sent: Saturday, May 14, 2011 7:03 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Please help to make my project good. You also could simplify the formula by inserting the following in the E2 cell: =OFFSET(INDIRECT("'"&$A$2&"'!$A$1";TRUE);$C$21+ROW(E2)-2;0) And tham just copy to the other.... 2011/5/13 Zafar Iqbal <ziqba...@gmail.com> -- ---------------------------------------------------------------------------------- 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