LittlegmoonBH
New Member
- Joined
- May 2, 2019
- Messages
- 15
I’ve inherited a transactional database that’s causing meproblems as there’s no governance around changing things… Fix #1 I guess!
In the meantime, I’m trying to get a solution.
What I need to build is a macro that can pull downloadeddata into a new sheet (I’ve got this already)
It then works through a list of values that I do not wantincluding in that data set, for example:
Row 346 - Column E contains “Non Billable” I want the row to be deleted.I need to build a list of things that can’t appear in “column E” and thereneeds to be a loop that works through this list as it’ll change infrequently,but often enough not to want to hard code these things in.
In summary, I need to build a loop that works through a listof things I want to be deleted from a separate sheet containing approx. 10,000rows of data. The end result being the only lines of data I want to report on.
Has anybody got any suggestions?
In the meantime, I’m trying to get a solution.
What I need to build is a macro that can pull downloadeddata into a new sheet (I’ve got this already)
It then works through a list of values that I do not wantincluding in that data set, for example:
Row 346 - Column E contains “Non Billable” I want the row to be deleted.I need to build a list of things that can’t appear in “column E” and thereneeds to be a loop that works through this list as it’ll change infrequently,but often enough not to want to hard code these things in.
In summary, I need to build a loop that works through a listof things I want to be deleted from a separate sheet containing approx. 10,000rows of data. The end result being the only lines of data I want to report on.
Has anybody got any suggestions?