thumperrock
New Member
- Joined
- Sep 1, 2023
- Messages
- 1
- Office Version
- 2016
- Platform
- Windows
I have two excel sheet (picture included)
1. original (main focus on column C and column J)
2. new 1 (main focus on column C and column J)
On original sheet I would like to focus on column C and column J.
On new 1 sheet, you can see column C and column J is different from original.
I would like to have formula or power query or script (not VBA) to copy column J data rfom original (not copy with header) to new 1 sheet. However, the data copy from column J from original should match with column C (as you see data) data from original in new 1 sheet.
Much appreciate your help.
1. original (main focus on column C and column J)
2. new 1 (main focus on column C and column J)
On original sheet I would like to focus on column C and column J.
On new 1 sheet, you can see column C and column J is different from original.
I would like to have formula or power query or script (not VBA) to copy column J data rfom original (not copy with header) to new 1 sheet. However, the data copy from column J from original should match with column C (as you see data) data from original in new 1 sheet.
Much appreciate your help.
