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

**SamuraiSam83** · 01-14-2015, 07:48 PM

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.

**Pauleyb** · 01-15-2015, 12:12 PM

Just so you know, people prefer a copy of the workbook instead of pictures. It allows them to work with your data and see your data more clearly.

I'm not positive, but I imagine you are hitting the limit of your IF nesting. This is a good place to use INDIRECT. It will allow you to remove the IFs. Here is an example: Use this formula in your C2 cell instead:
=COUNTIF(INDIRECT(A2&"!A2:A4896"),B2)

Use a similar technique for your other formulas to get rid of the IFs

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

LinkBack

Thread Tools

Rate This Thread

Display

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

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

Thread Information

Users Browsing this Thread

Similar Threads

Hard-coding sheets in workbook

ComboBox.Value reference to worksheet name and reference pivot table from another workbook

Reference / retrieve data from a table and populate a table in a different workbook?

VBA Coding for extracting data from a Pivot Table

Creating Excel Pivot table from data in mutiple sheets in a workbook

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions