Hello all!
So, I currently have a worksheet that I'm responsible for filtering out unnecessary data for my team. Here is the setup:
There is data in every cell in columns A:L, but I'm only going to do the first two columns.
A1:L1 have headers on them, so they can't change. Data in () is to show what cell the data is in.
On Sheet1 (where data gets pasted), this is how it looks starting in cell A2, etc.
(A2) Sally (B2) Order 1
(A3) Sally (B3) Order 2
(A4) Sally (B4) Order 3
(A5) Bill (B5) Order 1
(A6) Mike (B6) Order 1
(A7) Mike (B7) Order 2
(A8) Dave(B8) Order 1
On the Sheet2
There is a named range called "SF", which does not include Sally's and Dave's name. So, the macro would delete their rows, and move the others towards the top so it would look like:
(A1)Bill (B1) Order 1
(A2)Mike (B2) Order 1
(A3)Mike (B3) Order 2
I hope that is enough information. Any help you guys could provide would be greatly appreciated.
Thanks!
Bookmarks