+ Reply to Thread
Results 1 to 2 of 2

Copy Data From Active to New Sheet

  1. #1
    Forum Contributor
    Join Date
    06-16-2008
    Posts
    115

    Copy Data From Active to New Sheet

    Hi Experts,

    I wondering if there is a way to create a macro that takes data from an active sheet and inserts it into a table on a new sheet?

    Thanks in advance!

  2. #2
    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: Copy Data From Active to New Sheet

    Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.
    Manually add exactly what you want to see on another sheet.
    It may be the case that a Pivot Table will give you what you want.

    Incidentally would you add your location please. This is often useful where regional list separators/dates/time zones are involved
    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. copy the data from one hidden sheet to active sheet.
    By Kiran Kurapati in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-18-2014, 08:29 AM
  2. [SOLVED] Copy data from Specific columns from a csv file and pasting it in the Active sheet
    By Pavan Renjal in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-01-2014, 12:14 PM
  3. Replies: 1
    Last Post: 01-04-2014, 06:37 PM
  4. Auto copy data from one sheet to active sheet
    By rmartin10 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-06-2013, 09:13 AM
  5. Help to go through 86 spreadsheets copy data and then paste into active sheet.
    By Eliat in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-10-2013, 11:14 AM
  6. Copy the data in any active row in Sheet 1 to specific cells in Sheet 6
    By cti4sw in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-04-2013, 02:43 PM
  7. [SOLVED] Copy from active sheet and paste into new sheet using info from cell in active
    By Ingve in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-23-2006, 06:00 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