+ Reply to Thread
Results 1 to 2 of 2

How to copy data onto another sheet if conditions have been met

  1. #1
    Registered User
    Join Date
    02-18-2020
    Location
    NSW, Australia
    MS-Off Ver
    Office 2016
    Posts
    1

    How to copy data onto another sheet if conditions have been met

    I am wanting to copy data from a master sheet onto subsequent sheets if a condition has been met.

    eg:
    a b1 c d e
    a b2 c d e
    a b3 c d e
    a b1 c d e
    a b2 c d e

    If a cell in B is a certain value, then I want the whole row to be copied over to another sheet. My data also includes pictures that are set to resize and move with cells.
    Is this possible???

  2. #2
    Forum Contributor shank_mis's Avatar
    Join Date
    09-08-2018
    Location
    Delhi
    MS-Off Ver
    2010
    Posts
    128

    Re: How to copy data onto another sheet if conditions have been met

    Data can be filtered and copied..and that's easy. However, I am not sure about pictures.
    So far, I never came across a formula that copies pictures from one location to other.

    Macros are last resort I guess...
    Shashank Mishra
    Please hit "Add Reputation" Button if you liked the answer.

+ 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] Help to copy data to another sheet with conditions
    By sbv1986 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-29-2019, 10:07 AM
  2. Help to Copy data with conditions from another sheet by Macro VBA
    By sbv1986 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-30-2017, 06:46 AM
  3. [SOLVED] Copy data and paste it to next sheet with conditions
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-03-2017, 05:26 AM
  4. Copy Data from One sheet to other in same excel with some conditions.
    By Taj48 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-07-2013, 02:03 PM
  5. [SOLVED] Bulk import. (Copy Data from one sheet to a main sheet with conditions)
    By DanzaNZ in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-18-2013, 12:24 AM
  6. Copy data from one sheet to another sheet with conditions
    By cchoo13 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-22-2009, 11:10 AM
  7. [SOLVED] copy data from one sheet to another under conditions
    By nico in forum Excel General
    Replies: 5
    Last Post: 05-31-2005, 01:05 PM

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