Currency u selection

[josvill2010]

Hi, I hope you can help me.
In cell B4 there is a drop down menu to select a currency. At the moment it's showing a specific currency.
Is there a way to link the other cells to show the currency in cell B4

Monthly CashFlows SOE to Site Budget 2022-20027.xlsx
	C
12	DKK 30,000.00
Invoices

PO #:	70000150007
PO Value:	DKK 470,133.00
PO description
Currency	DKK
PO Line	Type	PO Amount	Billed per line	Remaining	Warning
Line 1	Preventative	DKK 290,133.00	DKK 24,177.76	DKK 265,955.24
Line 2	Corrective	DKK 30,000.00	DKK -	DKK 30,000.00
Line 3	Line 3	DKK 30,000.00	DKK 12,088.88	DKK 17,911.12
Line 4	Line 4	DKK 30,000.00	DKK 12,088.88	DKK 17,911.12
Line 5	Line 5	DKK 30,000.00	DKK 12,088.88	DKK 17,911.12
Line 6	Line 6	DKK 30,000.00	DKK 25,000.00	DKK 5,000.00	Request PO increase
Line 7	Line 7	DKK 30,000.00	DKK 22,000.00	DKK 8,000.00	Request PO increase
		DKK 470,133.00	DKK 107,444.40	DKK 362,688.60