internet connection only in a few cells

[jigglypuff]

Hello,

Is it possible to set only a few cells to be updated instead of the entire 'document' we are importing from the web?

i mean, i imported some data from the web but i do not need all of it, only a part, but I cannot get rid of the part I don't need cause every time I update the document it comes again with the new data! Is it possible to set the document to update only a few cells?

I tried to import only the part needed from the web but I couldn't, the document is available only in its entire format.

Thank you in advance

 

[chuckchuckit]

I would try importing the document to a different Sheet, or to an area of your active sheet you are not using. Then just copy the cells you need from there.

I do that all the time, and then just don't use the portion I do not need.

 

[rjwebgraphix]

Sounds like something I would use some code to automate the process for me. Like chuck said, import to another sheet and copy what you do need over to where you need it to be.

All could be done automatically with a little VBA and save some time deleting what you don't need.

 

[jigglypuff]

The problem is that I need some of the cells to being updating, and this document I am talking about is extremely long so I have a lot of data I will never use occupying a lot of space in the sheet... It is something I think unnecessary and then would like to correct. But if there is no way to do so it is OK for me. Copying the data I need and then letting the rest on the other sheet does not work for me cause as I said before I need some of the data up to date and my formulas 'pull' the data directly from their original sheet.

thank you anyway!

 

[chuckchuckit]

There are change event macros you can tie to the other sheet. And when one of those cells changes there, it will automatically copy the data you need immediately to keep things up to date.