+ Reply to Thread
Results 1 to 8 of 8

Copying cells from one sheet to another then filling down based on previous column

  1. #1
    Registered User
    Join Date
    05-01-2013
    Location
    Brisbane
    MS-Off Ver
    Office 365
    Posts
    16

    Copying cells from one sheet to another then filling down based on previous column

    Hi There,

    Don't suppose you can help me out.
    I'm trying to find code for the following
    Example attached
    The Yellow Cells (which are the green ones just transposed), need to go to column M to column R in the Sheet 2.
    They need to start in Row 2 and finish whatever the last row it.
    This sample has 4 rows... some other jobs I have can have from 2 rows to 3000.

    I'd prefer if the yellow cells I can get rid of, and some how just take the data from the green cells?
    Workbook is attached: CHECKLIST.xlsm

    Regards,
    Mark

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,870

    Re: Copying cells from one sheet to another then filling down based on previous column

    But while copying the cells from Sheet 1 to Sheet 2, how do you determine against which cells the copied cells are to be pasted to?
    Cheers!
    Deep Dave

  3. #3
    Registered User
    Join Date
    05-01-2013
    Location
    Brisbane
    MS-Off Ver
    Office 365
    Posts
    16

    Re: Copying cells from one sheet to another then filling down based on previous column

    Hi,

    Its determined by the number of rows. In this samples case 4 are required.


    Hath

    Rugs,
    Mark

  4. #4
    Registered User
    Join Date
    05-01-2013
    Location
    Brisbane
    MS-Off Ver
    Office 365
    Posts
    16

    Re: Copying cells from one sheet to another then filling down based on previous column

    Hi,

    I've uploaded a copy of what i'm trying to achieveCHECKLIST - FINAL.xlsm..... see how there is a row per existing data?

    Regards
    Mark

  5. #5
    Registered User
    Join Date
    05-01-2013
    Location
    Brisbane
    MS-Off Ver
    Office 365
    Posts
    16

    Re: Copying cells from one sheet to another then filling down based on previous column

    Don't suppose anyone has had alook?

  6. #6
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,164

    Re: Copying cells from one sheet to another then filling down based on previous column

    So the data in sheet 1 B6:B11 should be copied to all the rows present in sheet2?

    Do you want the action to happen on the click of a button or once a particular cell / cells is updated?
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  7. #7
    Registered User
    Join Date
    05-01-2013
    Location
    Brisbane
    MS-Off Ver
    Office 365
    Posts
    16

    Re: Copying cells from one sheet to another then filling down based on previous column

    Hi arlu

    That is correct.

    Button please.

    Rugs
    Mark

  8. #8
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,164

    Re: Copying cells from one sheet to another then filling down based on previous column

    Try this
    Please Login or Register  to view this content.

+ 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