+ Reply to Thread
Results 1 to 4 of 4

Copy Cells from One Sheet to Another

  1. #1
    Forum Contributor
    Join Date
    10-03-2012
    Location
    CDN
    MS-Off Ver
    Excel 2007
    Posts
    135

    Copy Cells from One Sheet to Another

    Hi All,

    I need top copy cells which have data in them into another sheet in different locations. The following codes works for columns which are adjacent to each others:

    Please Login or Register  to view this content.
    BUT:

    -When I include
    Please Login or Register  to view this content.
    **** hits the fan, as I just want to copy the "K" coloum start at row 3 to E on the new sheet???

    Can anyone help me out? I attached the file below:

    Help Me Please.xlsm

    Basically, I'm trying to pool select data from multiple sheets into a single sheet........and it's KILLING me....
    Last edited by Jrub; 11-30-2012 at 02:17 PM.

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,156

    Re: Copy Cells from One Sheet to Another

    hi Jrub. if your last row is 100, this code is going to give you "K3100"
    Please Login or Register  to view this content.
    because it adds K3 & 100. you probably know that because your series of codes seem to have include a letter. so maybe
    Please Login or Register  to view this content.
    i didnt try the rest of your codes.

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Forum Contributor
    Join Date
    10-03-2012
    Location
    CDN
    MS-Off Ver
    Excel 2007
    Posts
    135

    Re: Copy Cells from One Sheet to Another

    I see the error of my ways, thanks so much- It was driving me crazy.

  4. #4
    Forum Contributor
    Join Date
    11-05-2012
    Location
    Montreal
    MS-Off Ver
    Excel 2007
    Posts
    107

    Re: Copy Cells from One Sheet to Another

    Hello Jrub,

    Your codes seem interesting. Can you please explain the reason you created this macros? What do you want exactly?
    Plus, can you please attach the Excel workbook with the modifications you made. If possible.

    Thank you vey much

+ 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