Southerncentralrain
Board Regular
- Joined
- Jul 6, 2008
- Messages
- 115
I have the following code that works but the files will have different rows from week to week so I am trying to get the last rows for each range.
Columns("A:A").Select
Range("A1:A29807").AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:= _
Workbooks("old-Complete Daily Inventory File.xlsx").Sheets( _
"Complete Daily Inventory File").Range("A1:A29719"), Unique:=False
Do you guys have any idea of how I can accomplish this? I greatly appreciate your time.
Columns("A:A").Select
Range("A1:A29807").AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:= _
Workbooks("old-Complete Daily Inventory File.xlsx").Sheets( _
"Complete Daily Inventory File").Range("A1:A29719"), Unique:=False
Do you guys have any idea of how I can accomplish this? I greatly appreciate your time.