+ Reply to Thread
Results 1 to 1 of 1

How to paste tables from different sheets to a particular sheet in a list?

  1. #1
    Registered User
    Join Date
    01-11-2019
    Location
    India
    MS-Off Ver
    2010
    Posts
    69

    How to paste tables from different sheets to a particular sheet in a list?

    Hi all, I have a workbook where are 4 sheets namely (IMP, URIAGE, FILORGA, ISDIN respectively). In sheet IMP there is a dropdown list containing the names URIAGE, FILORGA, ISDIN and in each of those sheets there are tables with fixed header. What I want to do is when I select a item from the list in sheet IMP (cell A1) the table from the appropriate sheet should get pasted starting from the position B2 in sheet IMP.

    The end product should look like this
    pic1.png
    pic2.png
    pic3.png

    I've also tried name the tables for sheets URIAGE, FILORGA, ISDIN as TabU, TabF, TabI respectively and tried pasting the below formula on cell B2 but it shows "you have entered two many argument in this function" error:

    Please Login or Register  to view this content.
    Help !!
    Attached Files Attached Files

+ 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/paste tables from one sheet to another
    By Scavenger102 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-20-2017, 08:40 AM
  2. [SOLVED] Copy Paste From Rawdata Sheets to Multiple Sheets Based on Sheet names
    By farrukh in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-16-2017, 11:01 PM
  3. Collect Data from all 8 sheets into 1 sheet using Tables
    By farazexcel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-09-2014, 05:56 AM
  4. Need a creative copy/paste macro for sheets with tables.
    By T AWSUM in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-16-2013, 05:12 PM
  5. [SOLVED] Copy and Paste sheet into a range of sheets from list
    By adw223 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-20-2013, 01:11 PM
  6. Replies: 17
    Last Post: 05-08-2013, 04:51 PM
  7. [SOLVED] Macro to copy paste Tables to Master sheet
    By dawnmau in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-02-2013, 06:48 PM

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