Hello,



I'm new on the forum, I've already tried to scan the forum to find an answer to my question, unfortunately with no luck so far.

For a week now, I'm trying to figure out a way to copy data from the specific cells from one workbook to another.

*Both files are stored in network drives.

The aim is to set up one target workbook (Financial Result) to update specific cells automatically from another workbook (Batch File) filled by someone else.

At the moment, I'am copying the data manually, every month, from one file to another, which is time consuming.

I'm attaching two files:
1. The first one is Financial result (the target file).
2. The second one is FS - Batch File (the source file).

Please advice me in the matter.
Regards
Martin

Attached Files

	financial result.xlsx (12.0 KB, 11 views)
	FS - Batch File.xlsx (13.5 KB, 10 views)

Hi!

Why not refere directly to your cell?

In Batch_file, under this month, for Financial result, refere to your cell as follows:

='[financial result.xlsx]03.03.17'!$C$3

And you'll get the result...

Bye!

Souriane