Macro to copy formatting

[BokiB]

Hey,

I am looking for help on a very specific issue.

Let's say you have cell A1 and A2. And on the same worksheet I have a list of 20 countries (D1:D20) and right next to it (E1:E:20) the cells are formatted according to currency (so D1 has USA and E1 is formatted with currency $)

I am looking for a macro which can combine LOOKUP and copying the formatting. So if cell A1 states USA, it will search through the list and the formatting in cell A2 will be formatted with $.

Thanks for your help!

 

[Richard Schollar]

It wouldn't be in numeric format but you could do this:

Excel Workbook
	A	B	C	D	E
1	USA	$100.00	100	GBP	#,##0.00
2	GBP	43.40	43.4	USA	$#,##0.00
3				Euro	#,##0.00
Sheet1

Excel 2002

Cell Formulas
Range	Formula
B1	=TEXT(C1,VLOOKUP(A1,$D$1:$E$3,2,0))
B2	=TEXT(C2,VLOOKUP(A2,$D$1:$E$3,2,0))