View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
J.W. Aldridge J.W. Aldridge is offline
external usenet poster
 
Posts: 425
Default paste data from web to next available row

macro1
go to website http://abc.....com
copy data table from website.
paste in sheet 1
once sheet is full (65k rows), paste on next sheet (which will be
sheet2, sheet3, etc)

** each download may be up to 7,000 - 8,000 rows. I am going to run a
query from access to store this info. I had a web query performing
this on separate sheets initially, but need to consolidate in ms
access.