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
|