+ Reply to Thread
Results 1 to 1 of 1

Button macro that copies and pastes data from workbook to workbook: Ranged Column Q?

  1. #1
    Registered User
    Join Date
    07-26-2011
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    13

    Button macro that copies and pastes data from workbook to workbook: Ranged Column Q?

    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?

    Please Login or Register  to view this content.


    Also, something that I need help with in this example:

    Please Login or Register  to view this content.


    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.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1