Hi, i have this macro which refreshes a web query after every 5 seconds n copies some data from it into another column. 
Please Login or Register  to view this content.
I want to copy 12 cells from columns A F and G into another file n save it..... and after every 1 min copy another 12 cells from these columns n update into the earlier file n so on



Example.... copy a1-a12, f1-f12 and g1-g12 into a new file n save it as abcd.csv n close it,
then after 1 min, copy a13-24, f13-f24 and g13-g24 and add into the first blank row in the file abcd.csv and save it n close it,
and so on.


Thank U