Need help copying results from an autofilter to a new worksheet

[ozarkhigh]

I'm working on a quote template that has 600+ products with descriptions and prices that gets autofiltered down to one product. After it has been filtered down to that one product how do I link that to a new worksheet?

 

[ozarkhigh]

This is what I get.

Sub Macro3()
'
' Macro3 Macro
' Msgbox Sheets("Worksheet").Range("A12").CurrentRegion.Address
'

'
Application.Run "'elutron quote template.xlsm'!Macro3"
Sheets("Sheet2").Select
Application.Left = 321.25
Application.Top = 72.25
ActiveWindow.SmallScroll Down:=-90
Application.Left = 765.25
Application.Top = 128.5
Application.Run "'elutron quote template.xlsm'!Macro3"
Application.Left = 688.75
Application.Top = 128.5
End Sub

 

[wigi]

ozarkhigh,

How exactly do you execute a given macro? You seem to record another one?

 

[ozarkhigh]

I have Excel 2007, so I go to the developer tab, then click on Macros and choose the macro to run and click run. When I create a new one I click on record macro. The document has three macros right now. One that creates a unique quote # every time the document is opened and then the two you gave me.

Macro 1:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)

With Worksheets("Sheet1").Range("G3")

.Value = .Value + 1

End With

End Sub

 

[wigi]

What do you get if you ONLY execute this small macro?

Sub Macro3()
   Msgbox Sheets("Worksheet").Range("A12").CurrentRegion.Address
End Sub

 

[ozarkhigh]

I get $A$7:$H$613.

 

[ozarkhigh]

You still out there? I was hoping to finish this over the weekend...HELP!