Linking columns

[Bandito1]

Hi all,

I'm trying to make a new excel worksheet based on some kind of "database".

The database is also an excel worksheet with in column A batchnumbers.

I would like to link this column to my worksheet.
So if anything is added, deleted or changed that it also changes in my worksheet.

So the simple "=" doesn't work.

Anyone knows how to do this?

Edit:

Added attachements; Excel 2 is the source, excel 1 is the new one.
In excel 1 column A it should display the data that is in column A in excel 2.

When data is added, deleted or changed in excel 2 it should also change in excel 1.

[Pepe Le Mokko]

Administrative note

Welcome to the forum

in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you

[Bandito1]

Added the excels

[JeteMc]

If both worksheets are in the same workbook then you could populate column A of the new worksheet using: =INDIRECT("Tabelle1!A"&ROW())
If the worksheets are in different workbooks and the source workbook is open then: =INDIRECT("'[2.xlsx]Tabelle1'!A"&ROW())
(Untested) If the source workbook is closed then the path needs to be included as in: =INDIRECT("'C:\Source\[2.xlsx]Tabelle1'!A"&ROW())
This will generate zeros when the referenced cells are empty. The zeros may be hidden using conditional formatting as in Cells that contain > cell value = 0 > font > white
Let us know if you have any questions.