Reference to Data of a cell from another excel sheet - Increment Automatically

[Mathew123]

Hello Sirs,


I have an excel file as log showing the details of drawings received - such as Reference Number, Attachments details & Drawing Titles etc. (Say the file name name as "Register1").


I wanted to make transmittal for each item in another excel file (say file name as "Transmittal1").


So once i linked a cell in "Transmittal1" file =[Register1.xlsx]Sheet1!$A$1, i need to update next two cells of "Transmittal1" file with the corresponding data from "Register1" file.


If i copy paste manually it will be =[Register1.xlsx]Sheet1!$B$1 & =[Register1.xlsx]Sheet1!$C$1.


But is there a way to have these two data automatically while i link the first cell?


Note: The cells in "Transmittal1" are not in right order and not aligned to drag by removing the "$".


Register1

Doc No	Attachment	Title
PIC-P2B-OGE-KME-TS-0375	1	Water Supply Layout

<tbody>
</tbody>

Transmittal1

Doc No
PIC-P2B-OGE-KME-TS-0375
			Attachment
			1	Title
				Water Supply Layout

<tbody>
</tbody>

Thank you,
Mathew

 

[Mathew123]

Hello ..can anyone help with this one please??
Thank you

 

[Mathew123]

Hello, Can anyone please help on this?