Hi all
I am trying to automate the process of importing and sorting data from an application.
Ive been trying to use a macro in which an advanced filter, filters the data by organisation and this data is then copied to a different worksheet. My problem exists however in that the macro i recorded has a range of 287 rows so if the next month 500 rows are imported, only 287 rows will get filtered.
I found a sub that will find the number of rows and the result of this is a variable called lastrow.
Is there any way that i can assign this value to the range used within the advanced filter.
eg
lastrow = 500
Range("A1:I287) need to get 500 in where 287 is
Is there any way of doin this?
If my explanation doesnt make sense please ask for clarification as i will be online for most of the day.
Many many thanks in advance
Bookmarks