Select range using criteria

  • Thread starter Thread starter Eva Shanley
  • Start date Start date
E

Eva Shanley

Column B can have different line numbers keyed in such as
1, 2, 3. I need to import the rows of data to our Lawson
system by first creating a .txt file from Excel. However,
I need to hit 2 separate Lawson tables, the first table
needs all the Line #1 records, and the second needs all
the Line # greater than 1. How can I select a range
dependent on the line number? I looked at many of the
posts and VBA code but can't decide what I need to do.
Any help as always is much appreciated, and I really do
learn...just not as quickly as I'd like! TIA
 
Try looking at the Autofilter command. You would set the filter to show
just the records you want, then copy those to a new workbook (when you copy
a filtered range, buy default, only the visible rows are copied). You could
do a file saveas in that book to make a text file.
 
Thanks Tom, you're right of course. I was thinking
copying filtered data would include the invisible rows;
this should work fine. Thanks again.
 
Back
Top