Worksheet Columns added into one worksheet

Closed
lkwoodc Posts 1 Registration date Saturday 10 November 2012 Status Member Last seen 10 November 2012 - 10 Nov 2012 à 21:24
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 1 Dec 2012 à 08:16
Good Day!

I need to take Column/Row: M18 from worksheets 05202011 thru 12302011 (example: sheet 14 thru sheet 46), add and enter in to blank/another worksheet (sheet-PnL 2011, column-B2; example: sheet 4). Could you please help me find a formula?


Thank You,
LKC

1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
1 Dec 2012 à 08:16
Try this


=INDIRECT(TEXT(DATE(2011,5,20) +( (ROW() -2 ) *7),"mmddyyyy") & "!$M$18")