Hi,
I want to know can we link 2 Excel files(1 having Data and another one is having Format).I want to link these 2 excels same as we link Word and Excel file in Mail merge.
Please assist.
Kapil
Hello,
I have attached 2 Excel files.
1.Data- This file contains the data of 4 customers
2.TL_Review Format
I want data in file" Data" to be merged/linked with format in TL_review Format.So it should be 4 files for 4 "Name of Borrower"
Thank You
Kapil
Hello,
I have made a a new file which is attached herewith.
This file contains Data sheet and other sheet contains format9Sheet1,Sheet2,Sheet3,Sheet4,Sheet5.
I have linked Sheet1 with 1st record(i.e first row) of "Data" Sheet.
This Data sheet contains only 4 records so i may link all the sheets manually.What if Data sheet is having 20,30 or more records?
Now i have 2 queries:
1)Is there any way by which other sheets like Sheet2,Sheet3,Sheet4, can be linked to "Data" sheet with any formula in one go.
2)Everytime i will have to change date format in Sheet1 manually.Is there any way by the exact date which i enetered in Data sheet comes in linked Sheets(i.e formats)
Thank You
Kapil