| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use MS Query to query data within the current work book | Excel Discussion (Misc queries) | |||
| Importing Data via Web Query - Can values be passed to query? | Excel Discussion (Misc queries) | |||
| Save data retreived from query without saving query | Excel Discussion (Misc queries) | |||
| How to Process Query Data after Query is Refreshed | Excel Programming | |||
| Query returning more data than will fit on worksheet with VBA DB query... | Excel Programming | |||
Hybrid Mode
