+ Reply to Thread
Results 1 to 3 of 3

Copy-Paste based on cell value

  1. #1
    Registered User
    Join Date
    04-22-2013
    Location
    greece
    MS-Off Ver
    Excel 2010
    Posts
    66

    Copy-Paste based on cell value

    Hello,
    I want help with a macro code.
    I found a code at: http://stackoverflow.com/questions/1...-on-cell-value
    and i change it as in my case.

    In the attach file you will see at “sheet1” the master sheet and at sheet2 the result that I want to have. In sheet3 you see the result after I run my macro.
    How can be solved?
    As you can see the range of the groups varies.
    Please for help!
    Attached Files Attached Files

  2. #2
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Copy-Paste based on cell value

    give this a try

    Please Login or Register  to view this content.
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

  3. #3
    Registered User
    Join Date
    04-22-2013
    Location
    greece
    MS-Off Ver
    Excel 2010
    Posts
    66

    Re: Copy-Paste based on cell value

    Yes it is OK.

    But two questions:
    1. If i want the paste value to start at row 5 and not at row 3, how can be done?
    2. If i want case 1 and case 2 to be as it is now and case 3 to start at a35 and down and l35 (case 4)and down, case 5 at a70 etc, how can be done?

    I would be happy if you can help me!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Copy/Paste Based on Value of Cell
    By l8tnite in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-25-2012, 06:17 PM
  2. Copy Paste based on Cell Value
    By Bwbisel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-14-2011, 09:06 AM
  3. Copy and paste row based on cell value
    By contra76 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-20-2010, 03:23 AM
  4. Perform copy and paste based on cell value's
    By KevinThomas in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-19-2010, 01:12 PM
  5. copy and paste based on cell value / text
    By '''your code here in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-17-2010, 01:03 AM

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