Selecting defined area after auto filter

[brites]

Hi folks,
here's the deal: After I organize (ascending) certain column and auto filter it, i want to select only "copy to text values" rows, copy and paste them. The tricky part is that I dont want to copy the entire row; only columns BC to BF.
How can I determine this range (since the starting and ending rows are changing every update i have)?

Thx in advance,
Brites.

 

[Datsmart]

I would suggest looking at Advanced Filtering to do what you are after.
Good example of Advanced Filter steps here:
http://www.contextures.com/xladvfilter01.html

Another good link with sample VBA code here:
http://www.meadinkent.co.uk/xlfilter.htm

Advanced Filter allows you to preset filter options.
It also allows you to filter by criteria in ways standard autofilter can not do. You can choose an export location in the dialog box or in VBA code.
Once you setup the code and criteria, you can use a macro button to copy specific data from your main sheet to a "Report" sheet.

 

[brites]

Nice Links!
Thanks!