Linking data from one spreadsheet to another

Occasional Visitor

Hi I wanted to know how you can link a range of data from one spreadsheet to another spreadsheet for a full year calendar.  

Source sheet enters data daily:

Monday, 21 March 2022ALLWORTHEXTERNALSL 24 (31) LEICESTER RD MARULAN
 ALLWORTHINTERNALSL 3015 BOLD ST RENWICK
    
    
    
    
Tuesday, 22 March 2022SHAWOODINTERNALSL 22 HOUGHTON RD GLEDSWOOD HILLS
 SHAWOODINTERNALSL 21 HOUGHTON RD GLEDSWOOD HILLS
    
    
    
    
Wednesday, 23 March 2022DOMAINEEXTERNALSLot 9, 24 Highland Crescent THIRLMERE
 SHAWOODEXTERNALSL 110 HOUGHTON RD GLEDSWOOD HILLS

 

Need data transferred to destination sheet automatically without having to go = on destination sheet and enter to individual cells on source sheet please:

 

Monday, 21 March 2022Tuesday, 22 March 2022Wednesday, 23 March 2022
ALLWORTHSHAWOODDOMAINE
EXTERNALSINTERNALSEXTERNALS
L 24 (31) LEICESTER RD MARULANL 22 HOUGHTON RD GLEDSWOOD HILLSLot 9, 24 Highland Crescent THIRLMERE
   
ALLWORTHSHAWOODSHAWOOD
INTERNALSINTERNALSEXTERNALS
L 3015 BOLD ST RENWICKL 21 HOUGHTON RD GLEDSWOOD HILLSL 110 HOUGHTON RD GLEDSWOOD HILLS

 

Ideally I would like to run the formula across the rest of the weeks of the year on the destination worksheet please.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

0 Replies