+ Reply to Thread
Results 1 to 2 of 2

automatically pasting one cell into multiple cells

  1. #1
    Registered User
    Join Date
    11-24-2015
    Location
    Washington DC
    MS-Off Ver
    2013
    Posts
    1

    automatically pasting one cell into multiple cells

    Hello!

    I have a list where the first cell applies to all the cells below it that looks similar to this:

    Grocery
    Apples
    Bananas
    Kiwi

    Pharmacy
    Medicine
    Tissues

    I'm trying to copy and paste the first cells of the groups (Grocery and Pharmacy) to be in the same row as the others. Is there any function/macro that I can do to do this automatically?

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: automatically pasting one cell into multiple cells

    Attach a sample workbook. 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 use the paperclip icon to open the upload window.

    View Pic
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. Replies: 1
    Last Post: 06-04-2014, 07:15 AM
  2. Pasting information in one cell that goes into multiple cells.
    By dawidski in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-14-2013, 07:57 AM
  3. copying content of cell automatically to multiple cells
    By PAUL GRAZIDE in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-06-2005, 02:05 AM
  4. [SOLVED] copying content of cell automatically to multiple cells
    By PAUL GRAZIDE in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-05-2005, 11:05 PM
  5. [SOLVED] copying content of cell automatically to multiple cells
    By PAUL GRAZIDE in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-05-2005, 10:05 PM
  6. [SOLVED] copying content of cell automatically to multiple cells
    By PAUL GRAZIDE in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-04-2005, 02:05 PM
  7. automatically pasting cell into different sheets?
    By compitus in forum Excel General
    Replies: 1
    Last Post: 03-12-2005, 09:08 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