Copying data from one workbook to another. This is a continued working example that started in thread: http://www.excelforum.com/excel-prog...o-problem.html
What I am noticing is that there is a range in the first column that can probably go inside of a loop for the copying and pasting process below. How could the Range of ID#'s be copied?
Lets say the range is 1 to 100. Would it be best to use a loop? How would the loop for such a thing look?
Also, something that I need help with in this example:
WHen I change .Cells(rCnt, 2) to 2 instead of 1 it will move over the copied data but only one column of the two shows up. When I try 4, both columns show up moved over exactly where I want them but then a NA# shows up in the blank column to their right.
Bookmarks