Quasar Hunter
New Member
- Joined
- Oct 23, 2020
- Messages
- 4
- Office Version
- 2016
- Platform
- Windows
Hi everyone,
I have 3 tables on the same sheet Table 1 (A4:E23), Table 2 (J5:M19) and Table 3 (J21:M35).
I want to copy data from Table 1 in columns B,C,D,E to first empty row in
table 2 if the value in column A is "TK2", and copy to table 3 if value is "TK3".
Thanks!
I have 3 tables on the same sheet Table 1 (A4:E23), Table 2 (J5:M19) and Table 3 (J21:M35).
I want to copy data from Table 1 in columns B,C,D,E to first empty row in
table 2 if the value in column A is "TK2", and copy to table 3 if value is "TK3".
Thanks!