xcellrodeo
Board Regular
- Joined
- Oct 27, 2008
- Messages
- 206
Hi all,
I am looking for a solution for the following issue:
I have a large database (col.A to AA) with over 200000rows.
In Col. B I have data which looks like this:
X1094556
R3456992EX
What I would like is a VBA code which identifies all entries in Col B which end with "EX" and for the entire row to be cut and pasted to a separate spreadsheet ("Exclusions") starting in Cell B5 but with a function that copies new entries below the already existing ones (i.e using a Row Offset function or similar) so it doesn't overwrite existing entries.
Thanks
I am looking for a solution for the following issue:
I have a large database (col.A to AA) with over 200000rows.
In Col. B I have data which looks like this:
X1094556
R3456992EX
What I would like is a VBA code which identifies all entries in Col B which end with "EX" and for the entire row to be cut and pasted to a separate spreadsheet ("Exclusions") starting in Cell B5 but with a function that copies new entries below the already existing ones (i.e using a Row Offset function or similar) so it doesn't overwrite existing entries.
Thanks