Hi,
I want to do some Forex data entry into Excel and just need a little help on a certain simple Excel functions as follows and your help is appreciated.
1) When I enter a number in Column A, Row1, I want the same number (data) to appear at the same time in Column D, Row 1 as well. When I enter in A2, same number appears in D2, in A3 the same data also appear in D3, and so on and so on. So, date in A1 = D1, A2=D2.........AZ=D26, etc. This saves me time from entering the same data twice in 2 different locations on the same row but in different columns (as they are the same).
2) - Same requirement as 1), only that when I enter a data in A1, same data appears in both B1 and E1. When I enter a data in A2, same data appears in both B2 and E2, So on and on. So, entry in A1=B1=E1, A2=B2=E2, AZ=B26=E26 and I only need to enter A1, A2 ... AZ and don't have to retype the entries for all other redundant cells.
3) Similar to 1 and 2, only that when I enter a data in A1, it will appear also in E1. But when I enter a data in C1, it will appear in E1 also. Whichever data got entered in A1 or C1 first got prority to appear in E1 (as A1 and C1 will not be entered at the same time. If one is filled the other will be blank). So, either A1 or C1 will have an entry and this entry will appear in E1 as well. Same for A2, C2, E2, and so on and on.
Thanks.
I want to do some Forex data entry into Excel and just need a little help on a certain simple Excel functions as follows and your help is appreciated.
1) When I enter a number in Column A, Row1, I want the same number (data) to appear at the same time in Column D, Row 1 as well. When I enter in A2, same number appears in D2, in A3 the same data also appear in D3, and so on and so on. So, date in A1 = D1, A2=D2.........AZ=D26, etc. This saves me time from entering the same data twice in 2 different locations on the same row but in different columns (as they are the same).
2) - Same requirement as 1), only that when I enter a data in A1, same data appears in both B1 and E1. When I enter a data in A2, same data appears in both B2 and E2, So on and on. So, entry in A1=B1=E1, A2=B2=E2, AZ=B26=E26 and I only need to enter A1, A2 ... AZ and don't have to retype the entries for all other redundant cells.
3) Similar to 1 and 2, only that when I enter a data in A1, it will appear also in E1. But when I enter a data in C1, it will appear in E1 also. Whichever data got entered in A1 or C1 first got prority to appear in E1 (as A1 and C1 will not be entered at the same time. If one is filled the other will be blank). So, either A1 or C1 will have an entry and this entry will appear in E1 as well. Same for A2, C2, E2, and so on and on.
Thanks.