Results 1 to 6 of 6

copy data from list to specific cells multiple worksheets

Threaded View

  1. #1
    Registered User
    Join Date
    09-12-2019
    Location
    Wisconsin
    MS-Off Ver
    Office 365
    Posts
    3

    copy data from list to specific cells multiple worksheets

    Is there a way to copy lists (range I guess) to specific cells in multiple worksheets all within the same workbook. I have data in 4 columns that needs to be copied into it's specific sheet.

    A2:A110 - to cell B1
    B2:B110 - to cell A3
    C2:C110 - to cell B3
    D2:D110 - to cell C3
    E2:E110 - to cell D3

    each sheet coincides with name in Column B

    test workbook attached, "Template", "Staff Listing" to create named sheets

    "Ahlgren, Joseph" has completed cells from "Staff Listing", showing data to copy/paste to other sheets

    Any help appreciated.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 02-05-2018, 09:00 AM
  2. [SOLVED] Copy data from a list to cells on specific worksheets
    By WHATSXL in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-27-2017, 01:24 PM
  3. Replies: 2
    Last Post: 07-17-2016, 03:14 AM
  4. Replies: 2
    Last Post: 10-14-2014, 06:49 AM
  5. open folder has multiple worksheets ,copy specific data from a tab and paste them
    By Khaled Diab in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-29-2014, 05:27 AM
  6. [SOLVED] VBA to copy data from list to specific worksheets
    By nguerra in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-31-2014, 05:05 PM
  7. Copy cells from multiple worksheets into one list with Sheet names.
    By ksamarin88 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-11-2012, 04:45 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