Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Mail merge of 2 excel files

0

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

Answer
Discuss

Answers

0
Selected Answer

Such linkage is the very essence of Excel. Excel enbles linking of data and format between workbook, between worksheets, between tables, between cells and even within each cell. Therefore your question is too vague by far to enable more than an affirmative answer.

However, it may help you to take a slightly different logical approach to the problem, in fact the one that the creators of Excel took. The nomenclature they chose is to speak of storage and display. Data are stored in a database and they are displayed in reports. The same data can be displayed in very different reports.

For example, a list of employees with names, addresses, DOBs, dates of joining, staff levels and pay grades might be displayed in lists filtered by different criteria, in a report showing the data of a single employee only, even as charts showing staff composition by age, by duration of service or cost to the company.

Superimposing this idea upon your wish it becomes clear that your "workbook containing formats" must take the place of Excel's "reports". The task, then, is to extract the data you wish to show in the report from the database in another workbook (although I would urge you to consider having the data on different worksheets in the same workbook).

Once you have the design of the report you arrive at questions of how to link the data. You can find answers here. Excel can do whatever you might be able to imagine in this context. Just design your reports and post them here.

Discuss

Discussion

Hello,
Thank you for the reply.
I have attached 2 Excel files in my original post by editing it.
Your assistance is expected.
Thank You
Kapil
KDRAGHU (rep: 16) Nov 30, '19 at 11:20 am
Yes. This is precisely the setup I described in my answer. You should now employ someone to link the two files in the way you want.
Variatus (rep: 4889) Nov 30, '19 at 11:45 pm
Hi,
I have attached the new excel file which i have created.
This is having few records.SO I may link each sheet manually.What if more records like 10,20,or more records are there?

Please assist.

Thank You.
Kapil
KDRAGHU (rep: 16) Dec 1, '19 at 10:20 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login