Results 1 to 2 of 2

Coding In Table Needs To Reference Data In Other Sheets In Same Workbook

Threaded View

SamuraiSam83 Coding In Table Needs To... 01-14-2015, 07:48 PM
Pauleyb Re: Coding In Table Needs To... 01-15-2015, 12:12 PM
  1. #1
    Registered User
    Join Date
    12-31-2014
    Location
    US
    MS-Off Ver
    Microsoft Office Home and Student 2013
    Posts
    7

    Coding In Table Needs To Reference Data In Other Sheets In Same Workbook

    I have a table (Columns D&E) on Sheet2 and 8 other sheets (List1 through List8). The table on Sheet2 has coding that references List1 through List8. I have been able to get the coding to work for List1 through List3, but when I try to expand it to work with List4 through List8, I get an error that says there are too many arguments.

    Sheet 2 has a Nested Listbox. Cell A2 drops down a list of the available Lists. Cell B2 drops down the Symbols that are listed on each respective List. Cell C2 returns the number of times that the Symbol is listed on each List page. Cells A1:C2 work perfectly fine. I am only mentioning A1:C2 so that you can have a full idea of what I have.
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Hard-coding sheets in workbook
    By vio.coman in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-29-2014, 03:30 PM
  2. Replies: 5
    Last Post: 06-17-2014, 10:16 AM
  3. Reference / retrieve data from a table and populate a table in a different workbook?
    By philuptuous in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-17-2012, 06:21 AM
  4. VBA Coding for extracting data from a Pivot Table
    By hansonca1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-14-2011, 01:49 PM
  5. Replies: 3
    Last Post: 03-29-2009, 12:42 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