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. |
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) |