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
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 1 Dec 2012 à 08:16
Related:
- Worksheet Columns added into one worksheet
- Transfer data from one excel worksheet to another automatically - Guide
- Add worksheet vba - Guide
- How to split excel sheet into multiple worksheets - Guide
- Copy worksheet to another workbook vba - Guide
- Automatically transfer data from one worksheet to another - Excel Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
1 Dec 2012 à 08:16
1 Dec 2012 à 08:16
Try this
=INDIRECT(TEXT(DATE(2011,5,20) +( (ROW() -2 ) *7),"mmddyyyy") & "!$M$18")
=INDIRECT(TEXT(DATE(2011,5,20) +( (ROW() -2 ) *7),"mmddyyyy") & "!$M$18")