+ Reply to Thread
Results 1 to 3 of 3

Macro that copies a cell based on the value of another cell

  1. #1
    Registered User
    Join Date
    10-15-2019
    Location
    USA
    MS-Off Ver
    2013
    Posts
    1

    Macro that copies a cell based on the value of another cell

    Hello all!

    I am working on a file that needs to auto update (or by button push) multiple worksheets based on a cells value. For example: If, in Sheet1 Cell B2 has an "X" then Cell A2 needs to copy to Sheet2. If Cell B3 and C3 have an "X" the Cell A3 needs to copy to Sheet2 and Sheet3.

    I have worked out a macro that copies the rows based on cell value but I only need the cells in Column A not the entire row.

    Capture.PNG

    Any help would be greatly appreciated!

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Macro that copies a cell based on the value of another cell

    Hello chrsy05,

    Welcome to this Forum!

    We don't like to try and create a sample Workbook by assuming what your set-up might look like.

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

    Regards.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Macro that copies a cell based on the value of another cell

    What do you do with the Manager, Supervisor and Administrator sheets? Are you just lookiing to see an individual analysis

    If so it strikes me that if your master sheet recorded the data slighhtly differently you wouldn't need the three sheets or indeed a macro. You could use a Pivot Table and a Slicer to help you filter the data. If you really did need a subset of the master data on a separate sheet you could double click in the PT and that would automatically extract to a new sheet
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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. vba when doubleclick a cell, copies from above based on a condition of a cell above
    By thecdnmole in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-09-2019, 03:55 AM
  2. [SOLVED] Macro copies row based on a cell data but leaves blank rows between them.
    By JesterGrafix in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-07-2018, 12:55 AM
  3. [SOLVED] Print number of copies based on a cell value
    By A440 in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 05-15-2017, 10:48 AM
  4. Macro that copies based on cell value
    By freshfruit in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 02-12-2014, 03:13 PM
  5. [SOLVED] Wirte macro that copies data from 1 cell to a different cell based on data in a third cell
    By Geoff Jones in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 12-11-2013, 12:37 PM
  6. macro that copies data in cell and paste it to cell x columns to right in shhet
    By Stevebarnes in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-27-2013, 12:14 PM
  7. Macro that copies and pastes value from one cell, if another cell contains data
    By defensorfedei in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-02-2012, 11:54 PM

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