InfoMan206
New Member
- Joined
- Jul 17, 2012
- Messages
- 2
Using Excel 2003, I have a workbook with 7 worksheets each containing 160 rows plus a header, each worksheet has a key field (employee number) and several unique columns. Looking for an easy to understand solution to merge the columns from all the worksheets into a new sheet - once data is merged, the key field is only required in column A.
When the data is first exported from our in-house custom app it has an initial 13 rows of information which is normally deleted manually (along with a number of columns which do not contain useful data) - if there is an easy way to add part of the script to remove the first 13 lines of each worksheet prior to the merge it would be a bonus (the header line is initially on row 14 prior to me deleting the other info).
I've found scripts which will merge rows but not columns - any assistance would be great.
Thank you.
Jason
When the data is first exported from our in-house custom app it has an initial 13 rows of information which is normally deleted manually (along with a number of columns which do not contain useful data) - if there is an easy way to add part of the script to remove the first 13 lines of each worksheet prior to the merge it would be a bonus (the header line is initially on row 14 prior to me deleting the other info).
I've found scripts which will merge rows but not columns - any assistance would be great.
Thank you.
Jason