+ Reply to Thread
Results 1 to 2 of 2

Copy populated cells to another sheet

  1. #1
    Registered User
    Join Date
    06-04-2013
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    2

    Copy populated cells to another sheet

    Hi,

    I'm trying to write a macro to do the following.

    Starting at cell B3 check if B3 is populated is so check cell D3 is popluated.
    IF it isn't blank copy the contents from B3 and C3 to a second spreadsheet.
    IF it is blank move to B4 and start the chek again.

    The paste location in the second spread sheet is determined from the data in D3.
    I need to find the same value on the other spreadsheet (planning to use 'Match'), move over one column and find the next empty row and paste the two cells in the corresponding rows.

    The process should continue by checking B4, B5 etc until BX is found to be empty then end the routine, always checking the corresponding DX cell.

    Any help would be appreciated, I have some ideas on how to do some of these things but pulling it together into one clean process is becoming complicated and I'm sure it shouldn't be that hard.

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Copy populated cells to another sheet

    Duplicate post
    http://www.excelforum.com/excel-prog...her-sheet.html

+ 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