FryGirl
Well-known Member
- Joined
- Nov 11, 2008
- Messages
- 1,368
- Office Version
- 365
- 2016
- Platform
- Windows
I'm going to have the user filter a sheet. The two filtered columns are coming from filtering Column D and also Column H. Most of the time it will be a single filtered item from each of those columns.
How can I get the filtered item in Column D to Sheet2.Range("A1") and Column H to Sheet2.Range("A2")?
How can I get the filtered item in Column D to Sheet2.Range("A1") and Column H to Sheet2.Range("A2")?