Worksheet Columns added into one worksheet
Closed
                    
        
                    lkwoodc
    
        
                    Posts
            
                
            1
                
                            Registration date
            Saturday November 10, 2012
                            Status
            Member
                            Last seen
            November 10, 2012
            
                -
                            Nov 10, 2012 at 09:24 PM
                        
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 1, 2012 at 08:16 AM
        rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 1, 2012 at 08:16 AM
        Related:         
- Worksheet Columns added into one worksheet
 - Transfer data from one excel worksheet to another automatically - Guide
 - Add worksheet vba - Guide
 - Tweetdeck larger columns - Guide
 - Display two columns in data validation list but return only one - Guide
 - Excel vba copy worksheet to another workbook without opening ✓ - Excel Forum
 
1 response
                
        
                    rizvisa1
    
        
                    Posts
            
                
            4478
                
                            Registration date
            Thursday January 28, 2010
                            Status
            Contributor
                            Last seen
            May  5, 2022
            
            
                    766
    
    
                    
Dec 1, 2012 at 08:16 AM
    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")