View Single Post
 
Old 06-10-2010, 02:15 PM
mrphilk mrphilk is offline Windows XP Office 2003
Novice
 
Join Date: Jul 2009
Posts: 8
mrphilk is on a distinguished road
Default Copying data from one cell to another automatically

Hi

You may have seen my earlier post about invoice numbers. Well I almost have it cracked I just need to copy some data. My layout is similar to this;

A B

1 X Y
2
PK00001
3 PK00002
4 PK00003
5 PK00004
6 PK00005
7 PK00006

So, for example, if X (A1) is 1, then I would like the value from A2 (PK00001) to be displayed in B1.

Likewise if A1 is 2, then PK00002 and so on.

Is there a formula to do this?

Thanks
Reply With Quote