Update Data from Web

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
6,429
file from post#12 is updated with table from vertical to horizontal

Name31/08/201630/09/201631/10/201630/11/201631/12/201631/01/201728/02/201731/03/201730/04/201731/05/201730/06/201731/07/201731/08/201730/09/201731/10/201730/11/201731/12/201731/01/201828/02/201831/03/201830/04/201831/05/201830/06/201831/07/201831/08/201830/09/201831/10/201830/11/201831/12/201831/01/201928/02/201931/03/201930/04/201931/05/201930/06/201931/07/201931/08/201930/09/201931/10/201930/11/201931/12/201931/01/202029/02/202031/03/202030/04/202031/05/2020
AUD1.7458670381.7022635681.5987784561.6763636361.7047817051.648917021.618545221.6343085571.7317959591.7231156641.6888995031.6453813471.6326530611.7096101071.7313011511.7797351821.7296529651.7469002391.7685913021.8328951881.8204865851.7579835771.7817278941.7713517151.7973033211.8086329311.7971712441.7475412051.8132427091.8026216631.8626434441.8432948851.8447964011.8193093031.8118342541.765386421.8106332471.8206451181.8734979631.904136111.8799952991.959489161.9779640162.0268943971.9099016171.851633958
BRL4.2468693254.2054283823.868517494.2367155434.0067509173.8946634923.8461989333.9507673614.1099522924.17615754.2759828514.1113844784.067498074.2680714014.3321229784.394840034.4778693244.4782163584.4805745634.6791633334.7671668944.9755930665.0647254674.9112306665.41464235.2445621554.7194310984.9224188264.9679720084.8004064954.9732626555.110683915.1073648095.0130224484.8531593334.6036475565.0658642965.1130705755.1680540565.4513347025.3075928545.6022572025.7706147816.4304005966.7389678386.621747625
CAD1.7195717281.7060961871.62853971.6695601171.6571281741.6324255271.6392942971.6673874671.765534551.7292966291.6813937891.6355401481.6276515931.6656082021.7078528911.7351821331.6950508891.7392788081.7653113161.8167790611.7669395181.7151003651.7427910391.7146379741.6928905731.6977347011.6715987981.6971302831.7444915211.725204961.7524319921.7476406851.7478666171.7041931161.6611455021.6002532121.6185060451.6287130391.7035282641.714755061.7157968971.7376893381.7297075541.7617860411.7348829181.69611935
CHF1.2920076411.2631383341.2015546921.2672140761.2542923221.2389524421.248226951.2502191621.282184841.2471813661.2429918231.2702974731.2444956671.2993036811.3228916491.3296584651.3189364651.3230576731.3029463331.3463252941.3606184631.314552921.3056825241.2992602561.2570759971.2753296521.2826167681.2731845331.2597676991.3027244291.3205568821.3026913671.3260597351.2643613361.2386369971.2050467681.2045492191.2246395631.2779074221.2904664121.275740481.270448471.2440954111.1941157231.2148898221.189947607
CNY8.7624696378.6481307278.2349805668.5870967748.5498376518.5906741778.5317390548.6077636098.9220224218.7505293888.8004503438.8230820858.4871647118.906303168.7847882268.9079956818.7963662198.9113866458.741163838.8544976578.7055479768.5482436138.7094407778.9865501018.8772008028.9780232178.8817751178.8580635028.8036175428.7933042558.8901963078.7844576498.7585799098.6867058288.7206513868.3759536368.7128581688.7819087089.1184563419.0550894699.1919370019.1076923088.9857586598.7749737718.8217018588.81982062
EUR1.1791618521.1613997191.110494171.1730205281.1679786961.1613727431.1722642281.1688660831.1838102121.1446231331.1372294821.118318051.0872756141.1340697231.1382650561.1365573681.1271034571.1375270161.1310298031.142987771.13688041.1405109491.1286044811.1208249271.1143302881.1270145391.125201131.1227376841.1179054921.1418392751.1650259221.165093791.1594471761.1274846941.115386761.0914290081.1041793191.1290122271.1609952051.1733646231.1753643631.1880011881.1721268241.1281206641.1506817791.110025753
HKD10.18288810.051566159.426651869.6761290329.5483426389.6900296159.6421077319.71023809810.0628603210.0064098910.1290755510.2435696710.0601263410.4577105410.3319180910.5158833910.563213611.0809919210.812079411.0522345410.7777398810.4719434310.3231194610.3243667310.1908847810.208384999.990323279.97563659210.024817510.2921966710.4401467910.2755446810.203946769.8606428929.9119959859.5269746689.5565615869.63815158110.1472141910.0855382810.2812646910.198158610.027544989.5828209799.7002473979.584739366
INR87.9138268586.368070881.1704608685.4651026483.6196827884.5485163582.7958501881.1152151383.1762811882.7951696983.864419584.1766942582.1974927487.4016194585.7751015986.8187759386.3423238690.0693891590.0559859891.7773459891.1419963689.874543890.0773094190.1642008592.1824158794.5745520194.2136531988.7877801289.1303813293.2722829994.2406943690.5499242790.508185787.6517876387.5846299783.7087849187.0496328687.1162769791.8492331692.3291287894.2489421793.7398277492.9320752593.5195108593.9080605393.35594086
JPY135.6154046131.3426942127.6735147141.3255132144.1285711141.6177922139.3001583139.7379402144.1407314142.3911177145.2810663145.045851142.226523150.6271406150.2509874151.2530545152.1702377154.2486634147.8482158149.902846150.2046385145.2212591145.6351222146.6487335143.8043236147.8981179144.1945248144.8219338140.6884062142.5129599147.3058776144.9959222144.8497356136.7300689136.7464168132.1065671129.4981505132.7605478140.1669511141.3083016143.3239304142.975943139.9050577134.1335469133.3294977132.414972
NZD1.8103671911.7849552281.7004997221.7490909091.7704221081.7082631671.7240490011.7894170871.8819030931.8072454641.7688467361.7526280471.8017244191.8546576241.9356197281.9684037051.8991693251.9113866451.9120058811.9542804891.9491814461.9024863141.9465041481.9292759471.9566525521.972838951.9490733971.8588045091.9066996081.8962524841.9438457511.9224047541.9484509791.9318322751.8916959461.8426595941.9312096281.9616587452.0153715772.0052801411.9573342742.029462432.0638809122.0776598272.037282091.982839002
PLN5.1332452895.0163176664.8059966695.2179472145.1511364435.0216596025.0580856934.94021254.9985202374.7744520124.8058180664.7520688884.6298370174.88126294.8307968994.7684264364.7079111394.7210783764.7255556184.8126643054.8049113234.9108120444.9356131144.7937682134.7819255634.8206919874.8824727424.8165446634.8085586844.8797643245.0199801955.0106023544.9703181524.8304826764.7399475774.6835401594.8376304314.9430413334.9436336835.0671751255.003291025.109474315.0705034295.1336258935.2167309134.939059586
SGD1.7900856071.7693924721.6936146591.7805278591.7792987461.7654027061.7385850771.7462859281.8062576211.7762261781.7865875161.7801386711.7498613721.8180271721.805288381.8169006081.8060705791.8528040041.8279703671.8468396391.8208276491.7855839421.7940296821.7906299041.7790283041.7850783281.7661156931.7493375851.7429264531.7651693351.7929748941.7725736921.7696642241.7338459631.7171379181.6656298091.6907193731.7002924141.7616941241.7620416541.7760930891.7929313931.7953466571.7635910341.7633047581.744072463
TRY3.8830978943.8995156963.7717934484.2665102644.3299306224.7188897284.5004395994.5461877434.5879748564.542322444.5641568014.620219194.4646798524.7645671265.0270337955.3006762525.1242631565.3158912525.2537465365.5978969035.5588904056.0022810226.025055026.42445648.5119233347.8496562617.0049396336.5964207126.7731657976.8155244477.0692607917.392054067.7582088867.35909267.3230717756.7242941187.1129023356.9424090867.3975131487.4154297457.8564880117.8547074558.0112524188.1295759398.7427650888.44740698
USD1.3126429731.2962382261.2155469181.2475073311.2311663441.2490563851.2422484031.2496347291.2939045611.2843816171.2978062841.3114515771.2857034131.3388827151.3247128731.3467068251.3517351761.4170174041.3814398011.4082752321.3732378351.3342837591.3157271031.3154001351.2983062181.304632031.2735026391.2753177351.2800017891.3117449591.3299935921.3089828731.3006678421.2572581831.2693101331.2170524871.2185722961.2293814141.2949740521.2885890291.3204043251.3129789131.2866436151.2359689991.2514815031.236124678
ZAR19.0707025418.0293369616.4888395317.4656891516.8854680116.7748678916.1666959716.6451205717.1532915816.8687689616.9674638617.1903377316.805801718.0816076618.7064755918.3284650816.6872175216.8149243516.250296916.7116241917.0669622616.7690465318.1122961517.2243891519.1361711618.5334159818.8968528117.543674518.4000536617.4039142318.579716918.9493184218.5771264318.4720327417.9820422717.3137749318.5832275218.6937328519.6347509118.9142857118.5440761619.5901395920.038797422.1218821622.6191818721.56102922
 

smitpau

Board Regular
Joined
Apr 2, 2020
Messages
124
Office Version
365
Platform
Windows
**** wow thanks you've gone above and beyond.
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,625
Messages
5,512,473
Members
408,899
Latest member
cve60069

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top