rhadash
asked on
Trouble with macro copying columns from one worksheet to another same workbook
Hi,
I have some code I am trying to use to copy specific columns from one worksheet to another worksheet in the same workbook. I need help to determine why it doesn't work.
When code runs it takes you to directory to pick file, deletes some extraneous records than concatenates the record number with the seq num. Then I want to take specific columns and copy to new worksheet. This is where it bombs.
I have attached the code I'm using and data file.
Thanks.
CopyColumns.txt
Data-file101413.xls
I have some code I am trying to use to copy specific columns from one worksheet to another worksheet in the same workbook. I need help to determine why it doesn't work.
When code runs it takes you to directory to pick file, deletes some extraneous records than concatenates the record number with the seq num. Then I want to take specific columns and copy to new worksheet. This is where it bombs.
I have attached the code I'm using and data file.
Thanks.
CopyColumns.txt
Data-file101413.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER