web query data
 

hi all of you,
i am downlodaing evry day huge data from our inventory list, then i am
finding out myself new records as well as deleted records which taking too
long time,after checking i am keeping that result in other sheet i means
deleted and new records, is there any macro or other way that i could know
new data as well as deleted data ?
thanks in advance.

web query data
 

Many activities which are can be performed manually can be simulated with
code.

Naturally the code performs these actions much quicker than can be done
manually. It is hard to say if there is an opportunity to apply code (or
even formulas) in your case - but I would guess there is. Try checking out
this page and see if you see some useful ideas:


http://www.cpearson.com/excel/duplicat.htm

--
Regards,
Tom Ogilvy



"Tufail" wrote:

hi all of you,
i am downlodaing evry day huge data from our inventory list, then i am
finding out myself new records as well as deleted records which taking too
long time,after checking i am keeping that result in other sheet i means
deleted and new records, is there any macro or other way that i could know
new data as well as deleted data ?
thanks in advance.

web query data
 

Hi again,
no i couldn't find there what i wanted, there aren't any macro that could
find after refreshing web query data new entrys ? like as follow.
A_col has Stock#, B_col Name, C_col Year & D_col price first table yeastrday
and 2nd is today after refreshing query data.
A B C D
1 12 Car 2000 $5,000
2 25 Bus 2002 $4,000 <---- gone in new list (after refreshing
data)
3 50 Car 2001 $2,000
--------------------------------------------------------------
A B C D
1 12 Car 2000 $5,000
2 35 Car 1999 $4,800 <---- new data after refreshing
3 50 Car 2001 $2,000
4 65 Van 2004 $1,000 <--- new data after refreshing

really lokkforward your soonest help.




"Tom Ogilvy" wrote:

Many activities which are can be performed manually can be simulated with
code.

Naturally the code performs these actions much quicker than can be done
manually. It is hard to say if there is an opportunity to apply code (or
even formulas) in your case - but I would guess there is. Try checking out
this page and see if you see some useful ideas:


http://www.cpearson.com/excel/duplicat.htm

--
Regards,
Tom Ogilvy



"Tufail" wrote:

hi all of you,
i am downlodaing evry day huge data from our inventory list, then i am
finding out myself new records as well as deleted records which taking too
long time,after checking i am keeping that result in other sheet i means
deleted and new records, is there any macro or other way that i could know
new data as well as deleted data ?
thanks in advance.

web query data
 

sorry again , please don't forget reply to me.

"Tom Ogilvy" wrote:

Many activities which are can be performed manually can be simulated with
code.

Naturally the code performs these actions much quicker than can be done
manually. It is hard to say if there is an opportunity to apply code (or
even formulas) in your case - but I would guess there is. Try checking out
this page and see if you see some useful ideas:


http://www.cpearson.com/excel/duplicat.htm

--
Regards,
Tom Ogilvy



"Tufail" wrote:

hi all of you,
i am downlodaing evry day huge data from our inventory list, then i am
finding out myself new records as well as deleted records which taking too
long time,after checking i am keeping that result in other sheet i means
deleted and new records, is there any macro or other way that i could know
new data as well as deleted data ?
thanks in advance.

web query data
 

You will have to copy the data somewhere, so you have something to compare
the update with the next day.

NickHK

"Tufail" wrote in message
...
Hi again,
no i couldn't find there what i wanted, there aren't any macro that could
find after refreshing web query data new entrys ? like as follow.
A_col has Stock#, B_col Name, C_col Year & D_col price first table
yeastrday
and 2nd is today after refreshing query data.
A B C D
1 12 Car 2000 $5,000
2 25 Bus 2002 $4,000 <---- gone in new list (after refreshing
data)
3 50 Car 2001 $2,000
--------------------------------------------------------------
A B C D
1 12 Car 2000 $5,000
2 35 Car 1999 $4,800 <---- new data after refreshing
3 50 Car 2001 $2,000
4 65 Van 2004 $1,000 <--- new data after refreshing

really lokkforward your soonest help.




"Tom Ogilvy" wrote:

Many activities which are can be performed manually can be simulated
with
code.

Naturally the code performs these actions much quicker than can be done
manually. It is hard to say if there is an opportunity to apply code
(or
even formulas) in your case - but I would guess there is. Try checking
out
this page and see if you see some useful ideas:


http://www.cpearson.com/excel/duplicat.htm

--
Regards,
Tom Ogilvy



"Tufail" wrote:

hi all of you,
i am downlodaing evry day huge data from our inventory list, then i am
finding out myself new records as well as deleted records which taking
too
long time,after checking i am keeping that result in other sheet i
means
deleted and new records, is there any macro or other way that i could
know
new data as well as deleted data ?
thanks in advance.