Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight New Data from Web Table Import
I'm using Excel 2007's built-in 'data from web' to pull in a table that is
sorted alphabetically. The content of the table gets updated with new info added to the existing info so the table grows and nothing gets deleted. I'd like to be able to automatically have whatever is new since the last import be highlighted in some way so I can easily scan the spreadsheet and find those new lines. I've tried all sorts of formatting for the existing data but the new items inherit that formatting. Any ideas on highlighting the changes? I don't care if I have to manually un-do the highlighting for the next time the table gets updated, but just being able to see the new stuff at the time of importing is the important part. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight New Data from Web Table Import
Thanks for the reply, Don, but I'm not doing this via macros. I'm just using
the standard "From Web" button on the Data tab. I point to a table on a URL and import it. Well, I guess technically that's a macro behind the scenes, eh? "Don Guillett" wrote: If you are doing by macro then you should be able to delete the prior interiorcolor and color the new cells. If desired, send your file to my address below and I'll take a look. -- Don Guillett Microsoft MVP Excel SalesAid Software "tonydi" wrote in message ... I'm using Excel 2007's built-in 'data from web' to pull in a table that is sorted alphabetically. The content of the table gets updated with new info added to the existing info so the table grows and nothing gets deleted. I'd like to be able to automatically have whatever is new since the last import be highlighted in some way so I can easily scan the spreadsheet and find those new lines. I've tried all sorts of formatting for the existing data but the new items inherit that formatting. Any ideas on highlighting the changes? I don't care if I have to manually un-do the highlighting for the next time the table gets updated, but just being able to see the new stuff at the time of importing is the important part. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight New Data from Web Table Import
AFAIK, you would need a macro. Do you always use the same info for the url
or are there variables? If desired, send me your file and I'll take a look. -- Don Guillett Microsoft MVP Excel SalesAid Software "tonydi" wrote in message ... Thanks for the reply, Don, but I'm not doing this via macros. I'm just using the standard "From Web" button on the Data tab. I point to a table on a URL and import it. Well, I guess technically that's a macro behind the scenes, eh? "Don Guillett" wrote: If you are doing by macro then you should be able to delete the prior interiorcolor and color the new cells. If desired, send your file to my address below and I'll take a look. -- Don Guillett Microsoft MVP Excel SalesAid Software "tonydi" wrote in message ... I'm using Excel 2007's built-in 'data from web' to pull in a table that is sorted alphabetically. The content of the table gets updated with new info added to the existing info so the table grows and nothing gets deleted. I'd like to be able to automatically have whatever is new since the last import be highlighted in some way so I can easily scan the spreadsheet and find those new lines. I've tried all sorts of formatting for the existing data but the new items inherit that formatting. Any ideas on highlighting the changes? I don't care if I have to manually un-do the highlighting for the next time the table gets updated, but just being able to see the new stuff at the time of importing is the important part. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight New Data from Web Table Import
All of the ones I've done so far have been to the same URL's with no
variables. I'll email you a sample file. Thanks! "Don Guillett" wrote: AFAIK, you would need a macro. Do you always use the same info for the url or are there variables? If desired, send me your file and I'll take a look. -- Don Guillett Microsoft MVP Excel SalesAid Software "tonydi" wrote in message ... Thanks for the reply, Don, but I'm not doing this via macros. I'm just using the standard "From Web" button on the Data tab. I point to a table on a URL and import it. Well, I guess technically that's a macro behind the scenes, eh? "Don Guillett" wrote: If you are doing by macro then you should be able to delete the prior interiorcolor and color the new cells. If desired, send your file to my address below and I'll take a look. -- Don Guillett Microsoft MVP Excel SalesAid Software "tonydi" wrote in message ... I'm using Excel 2007's built-in 'data from web' to pull in a table that is sorted alphabetically. The content of the table gets updated with new info added to the existing info so the table grows and nothing gets deleted. I'd like to be able to automatically have whatever is new since the last import be highlighted in some way so I can easily scan the spreadsheet and find those new lines. I've tried all sorts of formatting for the existing data but the new items inherit that formatting. Any ideas on highlighting the changes? I don't care if I have to manually un-do the highlighting for the next time the table gets updated, but just being able to see the new stuff at the time of importing is the important part. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight New Data from Web Table Import
I sent OP a file that un highlightsfetches datahighlights if not on the list made from previous fetches. -- Don Guillett Microsoft MVP Excel SalesAid Software "tonydi" wrote in message ... All of the ones I've done so far have been to the same URL's with no variables. I'll email you a sample file. Thanks! "Don Guillett" wrote: AFAIK, you would need a macro. Do you always use the same info for the url or are there variables? If desired, send me your file and I'll take a look. -- Don Guillett Microsoft MVP Excel SalesAid Software "tonydi" wrote in message ... Thanks for the reply, Don, but I'm not doing this via macros. I'm just using the standard "From Web" button on the Data tab. I point to a table on a URL and import it. Well, I guess technically that's a macro behind the scenes, eh? "Don Guillett" wrote: If you are doing by macro then you should be able to delete the prior interiorcolor and color the new cells. If desired, send your file to my address below and I'll take a look. -- Don Guillett Microsoft MVP Excel SalesAid Software "tonydi" wrote in message ... I'm using Excel 2007's built-in 'data from web' to pull in a table that is sorted alphabetically. The content of the table gets updated with new info added to the existing info so the table grows and nothing gets deleted. I'd like to be able to automatically have whatever is new since the last import be highlighted in some way so I can easily scan the spreadsheet and find those new lines. I've tried all sorts of formatting for the existing data but the new items inherit that formatting. Any ideas on highlighting the changes? I don't care if I have to manually un-do the highlighting for the next time the table gets updated, but just being able to see the new stuff at the time of importing is the important part. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight New Data from Web Table Import
I just wanted to come back here and publicly express my appreciation for all
the time and effort Don put in to solve my problem. His solution was elegant and exactly what I needed. Thanks Don! "Don Guillett" wrote: I sent OP a file that un highlightsfetches datahighlights if not on the list made from previous fetches. -- Don Guillett Microsoft MVP Excel SalesAid Software "tonydi" wrote in message ... All of the ones I've done so far have been to the same URL's with no variables. I'll email you a sample file. Thanks! "Don Guillett" wrote: AFAIK, you would need a macro. Do you always use the same info for the url or are there variables? If desired, send me your file and I'll take a look. -- Don Guillett Microsoft MVP Excel SalesAid Software "tonydi" wrote in message ... Thanks for the reply, Don, but I'm not doing this via macros. I'm just using the standard "From Web" button on the Data tab. I point to a table on a URL and import it. Well, I guess technically that's a macro behind the scenes, eh? "Don Guillett" wrote: If you are doing by macro then you should be able to delete the prior interiorcolor and color the new cells. If desired, send your file to my address below and I'll take a look. -- Don Guillett Microsoft MVP Excel SalesAid Software "tonydi" wrote in message ... I'm using Excel 2007's built-in 'data from web' to pull in a table that is sorted alphabetically. The content of the table gets updated with new info added to the existing info so the table grows and nothing gets deleted. I'd like to be able to automatically have whatever is new since the last import be highlighted in some way so I can easily scan the spreadsheet and find those new lines. I've tried all sorts of formatting for the existing data but the new items inherit that formatting. Any ideas on highlighting the changes? I don't care if I have to manually un-do the highlighting for the next time the table gets updated, but just being able to see the new stuff at the time of importing is the important part. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight New Data from Web Table Import
Glad to help
-- Don Guillett Microsoft MVP Excel SalesAid Software "tonydi" wrote in message ... I just wanted to come back here and publicly express my appreciation for all the time and effort Don put in to solve my problem. His solution was elegant and exactly what I needed. Thanks Don! "Don Guillett" wrote: I sent OP a file that un highlightsfetches datahighlights if not on the list made from previous fetches. -- Don Guillett Microsoft MVP Excel SalesAid Software "tonydi" wrote in message ... All of the ones I've done so far have been to the same URL's with no variables. I'll email you a sample file. Thanks! "Don Guillett" wrote: AFAIK, you would need a macro. Do you always use the same info for the url or are there variables? If desired, send me your file and I'll take a look. -- Don Guillett Microsoft MVP Excel SalesAid Software "tonydi" wrote in message ... Thanks for the reply, Don, but I'm not doing this via macros. I'm just using the standard "From Web" button on the Data tab. I point to a table on a URL and import it. Well, I guess technically that's a macro behind the scenes, eh? "Don Guillett" wrote: If you are doing by macro then you should be able to delete the prior interiorcolor and color the new cells. If desired, send your file to my address below and I'll take a look. -- Don Guillett Microsoft MVP Excel SalesAid Software "tonydi" wrote in message ... I'm using Excel 2007's built-in 'data from web' to pull in a table that is sorted alphabetically. The content of the table gets updated with new info added to the existing info so the table grows and nothing gets deleted. I'd like to be able to automatically have whatever is new since the last import be highlighted in some way so I can easily scan the spreadsheet and find those new lines. I've tried all sorts of formatting for the existing data but the new items inherit that formatting. Any ideas on highlighting the changes? I don't care if I have to manually un-do the highlighting for the next time the table gets updated, but just being able to see the new stuff at the time of importing is the important part. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import data from a table | Setting up and Configuration of Excel | |||
External Data Range Import to a Cell not Table | Excel Discussion (Misc queries) | |||
Pivot Table Data Import | Excel Discussion (Misc queries) | |||
Import External Data Non-HTML Table | Excel Discussion (Misc queries) | |||
Is it possible to import external data into existing pivote table | Excel Discussion (Misc queries) |