+ Reply to Thread
Results 1 to 3 of 3

Copy and paste from one tab to another with certain rules

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

    Copy and paste from one tab to another with certain rules

    Hi. I need a code that does the following please. Copy and pastes a row from tab 1 (“April”) to tab 2 (“May”). However if there’s a ‘0’ in column H then I only want it to paste the row from column B onwards (to and inc column H). If there’s a ‘1’ in column H, I need it to copy and paste the entire row. I’d also like it to paste in the row same on the 2nd tab. For example if its in row 5 on tab 1 I’d like it to appear in row 5 on tab 2 and for it also to appear automatically in the 2nd tab after inputting the number 0 or 1 into the column H. Any help would be great
    Attached Files Attached Files
    Last edited by missexcel12; 04-15-2013 at 07:25 AM.

  2. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Copy and paste from one tab to another with certain rules

    a sample file would be helpful
    If solved remember to mark Thread as solved

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

    Re: Copy and paste from one tab to another with certain rules

    File now attached. What the May tab looks like it what I would like the code to be able to do

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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