I have a large excel spreadsheet where I am importing 10-15 web based
queries. I am then taking that information on a daily basis and comparing it
to other days that I have imported the queries. What I am currenly doing is
opening the spreadsheet, disabling the automatic refresh, copying and pasting
the data so that brining in new data doesnt overlap yesterdays data, saving,
closing, reopening and performing an auto refresh. for example, on monday i
have fri, sat and sun data, i copy sat and sun data, paste over fri and sat
data, and then important monday data, so I now how sat, sun and monday data.
Kind of conusing I know. Anyways, what I would like to do is generate a
macro button that when selected will automatically copy a range of rows,
paste that range to a different spot, and then automatically run a refresh of
all 10-15 queries. There is where I see the difficulty, I know I can
manually refresh one query at a time, but how do I do all 15, and program the
button to do everything else. Thanks so much for any help, I am looking at a
vba programming book right now trying to figure it out.