+ Reply to Thread
Results 1 to 3 of 3

Copy and paste based on wording in cell

  1. #1
    Registered User
    Join Date
    03-11-2020
    Location
    Bloomington
    MS-Off Ver
    2018
    Posts
    22

    Question Copy and paste based on wording in cell

    Hi everyone!

    I want to create a button, that when pressed, it will do the following below:

    1) Based on the wording "for a selection", I would like four columns to be copy and pasted onto another tab. It would start in tab 'A', then loop to the next tab 'B', and so forth.
    a. This is tab CC' and what the arrow is pointing at would be on tab 'After'.

    pic1.png

    2) Next it goes to tab 'B', and finds "for a selection" and copies over applicable cells that match the header on the 'After' tab. Also note, it goes directly under what was copied from tab 'CC'.

    pic2.png

    3) Lastly, it will add the names of the tabs above appropriate criteria.

    pic3.png
    Thank you!
    Attached Files Attached Files

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Copy and paste based on wording in cell

    I changed the out sheet name to "OUTPUT" and had the user put the "text to find" in cell H1. This way you can get a different report by simply changing the text in H1 and clicking the button again.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    “None of us is as good as all of us” - Ray Kroc
    “Actually, I *am* a rocket scientist.” - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    03-11-2020
    Location
    Bloomington
    MS-Off Ver
    2018
    Posts
    22

    Re: Copy and paste based on wording in cell

    Thank you! It works perfectly!

+ 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 and paste row based on cell value
    By juriemagic in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-22-2015, 04:28 AM
  2. VBA copy and paste based on cell value
    By Simon.xlsx in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-09-2014, 12:51 PM
  3. Copy and Paste based on a cell value
    By lzee61971 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-17-2014, 09:59 PM
  4. [SOLVED] If statement if cell x is <12 add this wording, if cell y is =>12 add this wording
    By Triscia in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 03-06-2013, 01:41 PM
  5. [SOLVED] Macro Help: IF specific wording is found in a cell, THEN copy entire row to new sheet
    By csch123 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-13-2012, 03:16 PM
  6. how do you update fields based on wording in another field w/o a formula in cell
    By juniperjacobs in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-17-2010, 09:17 AM
  7. Paste list, depending on wording in a cell
    By Zheno in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-08-2010, 05:16 AM

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