Item rows into order sheet
 

Hello everybody

I have an Excel (2000) project the part of whitch is to print out an order
with a list of items for that particular order number. I have a sheet with
columns OrderNumber, Item, Description, Qty and Prize.
In the Order sheet I enter the order number and want a macro to copy the
corresponding items rows to the order sheet.

I manually enter only the order number in a validation list box and want
this to trigger reading the items. I did it with Autofilter, but how to
scroll the autofilter list down. Copy an paste is not possible - but I want
to cell by cell copy the item information rows.

Sounds very simple - but I got stuck with it...

--
Håkan

Item rows into order sheet
 

If you enter the order number in A1 then you can use the following to trigger
the processing (add it to the worksheet's code)

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target
As Range)
If Target.Address = "$A$1" Then
'do your stuff
End If
End Sub

Or you can simply use VLOOKUP based on the value in A1 ....

"HBj" wrote:

Hello everybody

I have an Excel (2000) project the part of whitch is to print out an order
with a list of items for that particular order number. I have a sheet with
columns OrderNumber, Item, Description, Qty and Prize.
In the Order sheet I enter the order number and want a macro to copy the
corresponding items rows to the order sheet.

I manually enter only the order number in a validation list box and want
this to trigger reading the items. I did it with Autofilter, but how to
scroll the autofilter list down. Copy an paste is not possible - but I want
to cell by cell copy the item information rows.

Sounds very simple - but I got stuck with it...

--
HÃ¥kan

Item rows into order sheet
 

Sorry pasted the code for the wrong event...

Use this
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$3" Then
'do your stuff
End If
End Sub

"HBj" wrote:

Hello everybody

I have an Excel (2000) project the part of whitch is to print out an order
with a list of items for that particular order number. I have a sheet with
columns OrderNumber, Item, Description, Qty and Prize.
In the Order sheet I enter the order number and want a macro to copy the
corresponding items rows to the order sheet.

I manually enter only the order number in a validation list box and want
this to trigger reading the items. I did it with Autofilter, but how to
scroll the autofilter list down. Copy an paste is not possible - but I want
to cell by cell copy the item information rows.

Sounds very simple - but I got stuck with it...

--
HÃ¥kan

Item rows into order sheet
 

Sheeloo;269928 Wrote:
If you enter the order number in A1 then you can use the following to
trigger
the processing (add it to the worksheet's code)

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal
Target
As Range)
If Target.Address = "$A$1" Then
'do your stuff
End If
End Sub

Or you can simply use VLOOKUP based on the value in A1 ....

"HBj" wrote:

Hello everybody

I have an Excel (2000) project the part of whitch is to print out an
order
with a list of items for that particular order number. I have a sheet
with
columns OrderNumber, Item, Description, Qty and Prize.
In the Order sheet I enter the order number and want a macro to copy
the
corresponding items rows to the order sheet.

I manually enter only the order number in a validation list box and
want
this to trigger reading the items. I did it with Autofilter, but how
to
scroll the autofilter list down. Copy an paste is not possible - but
I want
to cell by cell copy the item information rows.

Sounds very simple - but I got stuck with it...

--
HÃ¥kan




I think it's the do your stuff the OP wants!


--
royUK

Hope that helps, RoyUK
For tips & examples visit my 'web site' (http://www.excel-it.com/)
------------------------------------------------------------------------
royUK's Profile: http://www.thecodecage.com/forumz/member.php?userid=15
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=75216