Copy GBP tab to a EUR tab

[leodo21]

Hi,

I have tab full of GBP values - such as

Type 2010 2011 2012 and so on.....
Green 56 112 372
Blue 966 999 1012
Red 566 456 223
and so on .....

I would like to copy the entire tab into tab 2, however each cell would be "XXX * EUR value" - what I mean is:
Cell B2 in tab2 would show the figure in cell B2 tab1, multiplied by a fixed cell (say $Z$999) which contains the exchange rate.
Cell C3 in tab2 would show the figure in cell C3 tab1, multiplied by a fixed cell (say $Z$999) which contains the exchange rate.
Cell D5 in tab2 would show the figure in cell D5 tab1, multiplied by a fixed cell (say $Z$999) which contains the exchange rate.
And so on.

Any formulea which I can use, without going into VBA?

Many thanks!

 

[ebea]

You can use this kind of formula. I put the exchange rate i K1. In A1 you put the name on Tab1

Mappe1
	A	B	C	D	E	F	G	H	I	J	K
1	Ark1										1,25
2		156,25
3			443,75
4
5				318,75
Ark2

Cell Formulas
Range	Formula
B2	B2	=INDIRECT(ADDRESS(ROW(B2),COLUMN(B2),1,1,$A$1))*K1
C3	C3	=INDIRECT(ADDRESS(ROW(C3),COLUMN(C3),1,1,$A$1))*K1
D5	D5	=INDIRECT(ADDRESS(ROW(D5),COLUMN(D5),1,1,$A$1))*K1

 

[Fluff]

Hi & welcome to MrExcel.
Another option without volatile functions.
In B2 on sheet 2 dragged down & across

=IF(Sheet1!B2="","",Sheet1!B2*Sheet1!$Z$1)

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)