Hello,
I'm currently creating a spreadsheet for my company that includes our stock price. The only problem that I'm having is when i import all the information and delete all the extra information that I don't want to incorporate and refresh, all the old information comes back.
Is it possible to delete all the unwanted information and format the cells so they have the fonts and background colors that I want and they stay after the sheet is refreshed?
Thanks
Nate
Last edited by VBA Noob; 02-17-2007 at 05:52 PM.
Refreshing will allways bring down all the information the query was set up to extract from the web
Can you refine the query to supply only the data required or build a macro to reformat the data etc after the wuery has run
The web query that i'm getting includes all this misc stock info like the highest and lowest it's been that day or alot of other misc stock info that I don't wanna include. When I import it it takes up like 15 rows and 10 columns. I wanted to get it down to just two and format the cells so they look just like the rest of the spreadsheet that I created and when it refreshes itself it stays in the same format that I switched it to.
Is this possible?
Thanks
Nate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks