Save Old Data when doing Web Query Refresh

C

Cocheezer

New Member
Joined
Sep 5, 2016
Messages
1
I know it's been asked a hundred times. I've tried reading through posts and different informational links but frankly, I just don't get it. I'm trying to save the old data and add the new data to it when I do the refresh. I know I have to have an archive sheet, I think I might need a Worksheet_Change Event. But I no nothing of macros! Please help!
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
You must log in or register to reply here.

Similar threads

R
  • Solved
VBA Queries refresh and Save data as TXT
Replies
2
Views
439
Artik
Artik
T
  • Question Question
VBA to run when a table with a SQL query is refreshed?
Replies
3
Views
400
DickyWest32
D
T
  • Question Question
Web query basics
2
Replies
13
Views
978
Domenic
D
K
  • Question Question
Import Data from Multiple Web Pages
Replies
0
Views
459
Ka001
K
S
  • Solved
How do I automate opening an excel document every 24 hours in the background, refresh connections, save and close the workbook in excel using vba?
Replies
6
Views
482
SPS41
S

Forum statistics

Threads
1,226,739
Messages
6,192,739
Members
453,754
Latest member
milestogo

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top