I am attempting to read data from multiple columns and lines into an array(?). The Range is ("A2:J" & LastRow).
I then need to write the data into another worksheet into a single line starting with Column 26.
I have attached a sample worksheet and the code I have to far in the module. Any help would be appreciated.
Please Login or Register to view this content.
Kind regards, Harry.
Now how would I reverse that function? Where it reads CLAIM_INFO from row (where row = DCN) starting at column 26 to endCol and the puts that data into the BILL_INFO where every 10 columns is a new line?
Last edited by lloydgodin; 06-15-2012 at 06:06 PM.
Please Login or Register to view this content.
I appreciate the help. I am having the following issues:
I need the Row to be a variable based on rowNbr = DCN+1
The same goes with this section:Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by lloydgodin; 06-15-2012 at 06:11 PM. Reason: additional issues
Both codes are variable.
1). The code is variable from Range ("A2") to the row of the filled-in cells.
2). As well as the number of completed columns.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks