*UPDATE* Rows of data to Columns of data *UPDATE*

[a6ela]

Thanks for the help so far, thou a slight change......

So far the VBS works fine BUT needs to be altered, something a little more advanced.
it was quite easy to understand how the VBS pulls the data but how can it skip a column of data and a column to add the number "000" to the front of the accountID.???

new test excel file attached.

thanks once again!!!
_lex

-------------------------------------------------------------------------------------------------------------
Hi all,

Such a wonderful site here,
but for the life of me, i can not work out how to setup a Macro or VBS to convert my simple rows of data to making it columns of data.

Problem is:
a) program scans 3x fields of data in (per page), then out puts it to a excel file.
b) each field is on a different row i.e. name\date\code.
c) each other page continues after the last row.
d) 100 pages are scanned in.

Question being, is there a easy way to output this data so it reads\shows in Columns rather than Rows.

Any bit of help would go along way!

Attached is a dummy file which shows the way the data is entered and how it should look like in the end.

thanks for your time!