Help required please

[Eamon]

Hi,

I have a spreadsheet where I get data from a web query, this data is in
Column A Row 10 to Column T Row 50.

This data changes when I refresh the query and can be 10 rows 15 rows 23
rows up to a maximum of 40 rows.

What I want to do is to save the data I already have to a separate worksheet
before I refresh data.

Any suggestions on how I could accomplish this task would be very welcome.

Best regards,

Eamon

 

[Guest]

hi,
add this to public
sub copyquery()
Application.Goto Reference:="your query name"
Selection.Copy
Sheets.Add
Range("A1").select
Selection.PasteSpecial Paste:=xlValues, _
Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Selection.PasteSpecial Paste:=xlFormats, _
Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
End Sub