ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Refreshing data (https://www.excelbanter.com/excel-programming/441341-refreshing-data.html)

MarkGMaxim

Refreshing data
 
My company downloads a csv file daily from an external website, we then take
this data and make it look pretty with pivot tables and such every day. Is
there anyway we could take the pivot tables and formating of cells and
refresh them with the new data daily? I'm a .NET developer and I'm pretty
sure I could do it in .NET but there has to be an easier solution. Thanks.

ryguy7272

Refreshing data
 
Pretty simple:
http://www.ozgrid.com/VBA/pivot-table-refresh.htm

I'm trying to learn .NET now. I thought it would be fairly easy. It's not
exactly hard, but definitely NOT easy.

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"MarkGMaxim" wrote:

My company downloads a csv file daily from an external website, we then take
this data and make it look pretty with pivot tables and such every day. Is
there anyway we could take the pivot tables and formating of cells and
refresh them with the new data daily? I'm a .NET developer and I'm pretty
sure I could do it in .NET but there has to be an easier solution. Thanks.



All times are GMT +1. The time now is 11:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com