Tables from Data Connection

**milty456** · 10-08-2012, 09:17 AM

Hi,

I'm not sure I know how to articulate this correctly, but I will try.

I have a sheet of data connections that bring in sets of data in tables.

I want to take each of those tables in their entirety, and insert them into other sheets. Is there a way to do this(especially since the data may be different each time; most likely it won't be as the data I'm using is static, but there's always a chance).

Thanks

Rich

**K m** · 10-08-2012, 09:21 AM

Yes, but you either need to include sample data or explain the problem better

**milty456** · 10-08-2012, 09:26 AM

Sheet1:
Has data connections that pull in different sets of data. the end result is I have a sheet with a bunch of tables on it(column headers and data).
It is strictly used to set data connections/sources and pull in data depending on the user's chosen parameters(some dropdowns on the page that they can choose certain record id's which refreshes all of the tables with new data based on recordid chosen)

Sheet2: I want to reference table 1; I want to insert whatever data is returned for the first table on my data sheet(sheet 1), into this sheet.
Sheet3: I want to reference table 2; I want to insert whatever data is returned for the second table on my data sheet(sheet 1), into this sheet.
Sheet4: I want to reference table 3; I want to insert whatever data is returned for the third table on my data sheet(sheet 1), into this sheet.

**K m** · 10-08-2012, 09:35 AM

I want to reference table 1; I want to insert whatever data is returned for the first table on my data sheet(sheet 1), into this sheet.

Do you mean?
=+Sheet1!A1

**milty456** · 10-08-2012, 09:52 AM

Not really. I want =Sheet1!A1-D24(or ideally, for it to somehow know that if different data were ever to be pulled, A1-G24)I want the entire table of data that is returned. I wanted to originally convert to a range...then perhaps i could insert that entire range; however when you try to do that, it removes the data connection and you can no longer pull data at will.

**K m** · 10-08-2012, 10:18 AM

If your entire worksheet (say Sheet2), is a series of formulas, ie =Sheet1!A1, =Sheet1!A2, =Sheet1!A3, =Sheet1!A4, etc., the data is not static but will change whenever those data cells changes

**milty456** · 10-08-2012, 10:25 AM

That doesn't seem to be working, although I'm not entirely sure what that formula does.
I have an indeterminate range from sheet 1(defined # of columns, possibly changing row count based on records pulled from DB) that I'd like to be able to insert into sheet 2(not exclusively; there will be other data here(definitions, explanations, etc)).

When I put =Sheet1!A1 into my sheet 2, it opens up something that looks like a save dialog "update values sheet" and want's me to pick a sheet.

Unsure what is happening.