Macro Help

[RichardJ]

I have a macro that creates a new list on a new sheet after matching information in one coloum of the master sheet. This way, if C4 = "FCA" then it first breaks down the master list into FCA via using filter, into only FCA related rows and then copies all the information into a new sheet. However, in this macro how can I add a feature that would allow the user to always reach the end of the list on the new sheet, so that they do not have to scroll down for 20 seconds.

Application.CutCopyMode = False
Sheets("FCA").Select
Range("A146").Select
In this code section what should I mention in Range line so that it cursor always ends up at the last item.

Each day items are added to the master list so cannot give macro a commad to reach certain cell from the F5 feature.

Thanks

 

[Von Pookie]

To find the last used cell in column A for example, use:

[A65536].end(xlup).select

Is that what you mean?

 

[RichardJ]

Works good, Thanks!