+ Reply to Thread
Results 1 to 3 of 3

Using other sheet range to create new table

  1. #1
    Registered User
    Join Date
    10-29-2013
    Location
    israel
    MS-Off Ver
    Microsoft Office 2013
    Posts
    58

    Using other sheet range to create new table

    Hi

    i have this code that's create a new table from the cells that selected.
    how can i make it take his range from other sheet, but the new table will be create on the sheet im using?

    Please Login or Register  to view this content.
    Thanks!
    Last edited by damaple; 11-02-2013 at 04:00 PM.

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,088

    Re: Using other sheet range to create new table

    Perhaps try
    and adapt the sheet's name to your need


    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    10-29-2013
    Location
    israel
    MS-Off Ver
    Microsoft Office 2013
    Posts
    58

    Re: Using other sheet range to create new table

    Thanks! it works!

+ 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. Create Filter for Pivot Table on Different Sheet
    By cp41 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-18-2013, 12:37 PM
  2. Replies: 4
    Last Post: 04-26-2012, 07:24 AM
  3. Create table of contents sheet
    By davemcochrane in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-25-2008, 07:53 AM
  4. Replies: 1
    Last Post: 02-04-2008, 04:35 PM
  5. Using dynamic range to create pivot table
    By cursednomore in forum Excel General
    Replies: 3
    Last Post: 06-13-2006, 04:40 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