Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Please help: How to reference data from on Excel worksheet to another

Status
Not open for further replies.

cojeda

MIS
Dec 13, 2007
10
US
Any help would be greatly appreciated!

I have an Excel report that I wish to automate. There are two worksheets, a report worksheets and data worksheets. The data worksheet pull data via a web query. The report worksheet presents that data in a nice format, along with other details.

I was simply referencing a table of data from the data worksheet. The data is always in the same format (same number of columns wide and number of rows deep). This would work except for the fact that sometimes the table of data starts one or two rows lower or higher. This data is updated every 10 minutes.

How can I automate copying and pasting this data from the report worksheet even though the data may vary in row numbers where it begins. The headers are always the same. Plus, I would like it to refresh every 10 minutes or so.

Thank you!

~ Chris ~
 





Hi,

I don't understand.

You say that the DATA start row varys.

Are you just importing the table, or are you importing other stuff? Is the other stuff necessary?

In Excel 2003, when you do a web query, you can navigate to the page and select the particular table you want to download. Are you able to do that?

Skip,
[sub]
[glasses] When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[tongue][/sub]
 
The table contains other stuff, but I was unable to avoid the additional data. The data I need is a subset of a larger table that has data that I don't want.

C.
 




What is the logic for determining the data that you want?

Might help to post an example.

Skip,
[sub]
[glasses] When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[tongue][/sub]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top