Worksheet Columns added into one worksheet
Closed
lkwoodc
rizvisa1
- Posts
- 1
- Registration date
- Saturday November 10, 2012
- Status
- Member
- Last seen
- November 10, 2012
rizvisa1
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Related:
- Worksheet Columns added into one worksheet
- Same Date in Column A on Mutiple Lines in seperate worksheets ✓ - Forum - Excel
- Protecting column in worksheet ✓ - Forum - Excel
- Populate data from a column in one worksheet to a cell in multiple other sheets ✓ - Forum - Excel
- Excel macro to compare columns in two worksheets ✓ - Forum - Excel
- Vba split data into multiple worksheets based on column ✓ - Forum - Excel
1 reply
rizvisa1
Dec 1, 2012 at 08:16 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Dec 1, 2012 at 08:16 AM
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")