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.

Highlight New Data from Web Table Import
 

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.

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.

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.

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.

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.

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.

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.