Paste as Values to New Sheet

[Webbers]

Hello all,
First, thanks in advance for your assistance. I found this code and it works fine for copying and pasting values from one sheet to another if you only want to capture column A data only. I have been working on trying to modify this code every way I can think of for my needs, and everything results in multiple errors. It should not be this difficult.

1) My number of columns is constant, always A - AS (45 columns total).
2) The data will always begin on Row 2, row 1 is the headers
3) The number of rows will vary daily as I run this.

Please Login or Register  to view this content.

[TMS]

Try:

Please Login or Register  to view this content.

[Webbers]

TMS,

I tested it on my text file, worked perfect. Then I tested on a copy of my live data... PERFECT!!!! Such a simple modification in the code, but I never would have found the solution on my own. Thanks so very much HUGE help!!!!!

[TMS]

You're welcome.