Thread
:
Import data and macro
View Single Post
#
5
Posted to microsoft.public.excel.misc
Jambruins
external usenet poster
Posts: 65
Import data and macro
Don,
Email sent. Thank you very much.
"Don Guillett" wrote:
It is part of a macro. Send me a workbook (to the address below) along with
very detailed instructions as to what you need. Also send snippets of these
posts so I will know where it came from.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Jambruins" wrote in message
...
Don, I am not very familiar with macro's. Is that a formula I should put
in
in the destination cell or is that something I need to incorporate into
the
macro? Thanks for the help.
"Don Guillett" wrote:
I do this all the time for myself and clients. Just determine the next
available row in the destination sheet and copy to that
lr=sheets("dest").cells(rows.count,"a").end(xlup). row+1
range("myrange").copy sheets("dest").range("a" & lr)
or
with sheets("dest")
lr=.cells(.rows.count,"a").end(xlup).row+1
range("myrange").copy .range("a" & lr)
end with
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Jambruins" wrote in message
...
I have a spreadsheet that uses a web query to gather data. Everyday I
refresh this query and copy and paste the date it imports into another
tab.
I do not overwrite the data from previous days. I just copy and paste
the
data below the previous days. Is there some way I can have excel do
this
automatically? Maybe some kind of macro? Thanks.
Reply With Quote
Jambruins
View Public Profile
Find all posts by Jambruins