lihong3210
New Member
- Joined
- Dec 7, 2023
- Messages
- 2
- Office Version
- 2011
- Platform
- Windows
Hi all,
Calling for help and hope VBA or macros can make my life easier. The below screenshot is the current file and I'm trying to eliminate as much duplicate rows on column A as possible. The file is showing mapping of local accounts (column C to I) and how it mapped to consolidated group accounts (column A & B). Is there a way to move E173 to E172 and F174 to F172 to get rid of row 173 and row 174? The file has over 3000 rows and I just want to make them automated instead doing one by one.
Greatly appreciate if someone can help!
Calling for help and hope VBA or macros can make my life easier. The below screenshot is the current file and I'm trying to eliminate as much duplicate rows on column A as possible. The file is showing mapping of local accounts (column C to I) and how it mapped to consolidated group accounts (column A & B). Is there a way to move E173 to E172 and F174 to F172 to get rid of row 173 and row 174? The file has over 3000 rows and I just want to make them automated instead doing one by one.
Greatly appreciate if someone can help!