cadandcode
Board Regular
- Joined
- Jan 21, 2023
- Messages
- 125
- Office Version
- 2019
- Platform
- Windows
- Mobile
Hi, I manage and edit more than 2 different sheets from different files. When we drag cell vertical down, it copies formula and automatically perform process. (like A1=B300, A2=301 and so) But how can I take datas from in horizontal condition to vertical condition? (like A1=B300, A2=C300, A3=D300)
Example;
Example;
sheet 1 | A | sheet 2 | A | B |
1 | =pinkcar1 (=A1 in sheet 2) | 1 | =pinkcar1 | =pinkcar2 |
2 | =pinkcar3 (=A1 in sheet 2) | 2 | =pinkcar3 | |
3 | =pinkcar2 (=B1 in sheet 2) | 3 | ||
4 | 4 |