Please some1 tell me this one 2 - last one i need V URGENT!

[Sami]

ive got this macro:

Sub EnterAnotherSale()
'
' EnterAnotherSale Macro
' Enters another sale into the system
'
Rows("5:5").Select
Selection.Insert Shift:=xlDown
Range("F5").Select
ActiveCell.FormulaR1C1 = "=RC[-2]*RC[-1]"
Range("A5").Select


'Look for the ProductID in the Stock Table.
StockWorkbook.Seek "=", ProductID

'When found, take the current quantity and subtract from it the sold quantity.
If Not StockWorkbook.EOF Then
StockWorkbook.Edit
StockWorkbook!Quantity = StockWorkbook!Quantity - SalesWorkbook!Quantity
StockWorkbook.Update
'

End Sub

But the bit 'Look for the ProductID in the Stock Table.
StockWorkbook.Seek "=", ProductID

'When found, take the current quantity and subtract from it the sold quantity.
If Not StockWorkbook.EOF Then
StockWorkbook.Edit
StockWorkbook!Quantity = StockWorkbook!Quantity - SalesWorkbook!Quantity
StockWorkbook.Update

needs to run AFTER all the sale data has been entered and enter has been pressed in CELL F5. Plz can you give me the intermidiate code!?!?!?

 

[Jack in the UK]

Sami

Can i request you postt your amended codes, to what i discribed, ill help, but i wil not post the code answer you need to do that, i and i have spoken to few guys all will help you and agree your studying and so we will help and assist, but two guys i spoke with in London today agree you need to understand your work

What if teacher askes to explain that code?? If you dont know they will know you have had help, or i or someone presented you pass, but you could fail on techi issues, WE do not want that!

Post you code, i have re read you codes above and they do not make sence and will not run....

tidy them and post i / we will look at them and advise.

the then if.. did this work, did you try?