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[TABLE="class: cms_table_grid, width: 500"]
<tbody>[TR]
[TD]Doc No[/TD]
[TD]Attachment[/TD]
[TD]Title[/TD]
[/TR]
[TR]
[TD]PIC-P2B-OGE-KME-TS-0375[/TD]
[TD]1[/TD]
[TD]Water Supply Layout[/TD]
[/TR]
</tbody>[/TABLE]



Transmittal1
[TABLE="class: cms_table_grid, width: 500, align: left"]
<tbody>[TR]
[TD]Doc No[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PIC-P2B-OGE-KME-TS-0375[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Attachment[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD]Title[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Water Supply Layout[/TD]
[/TR]
</tbody>[/TABLE]





Thank you,
Mathew

 

[Mathew123]

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

 

[Mathew123]

Hello, Can anyone please help on this?