Код |
---|
Cells(NextRow, 1) = TextOrderDate.Text Cells(NextRow, 2) = TextInternalOrderNumber.Text Cells(NextRow, 3) = TextInternalItemNumber.Text Cells(NextRow, 4) = Application.WorksheetFunction.VLookup(TextInternalItemNumber, Sheets("ItemNote").Range("R2C1:R5C11"), 3, False) Cells(NextRow, 5) = Application.WorksheetFunction.VLookup(TextInternalItemNumber, Sheets("ItemNote").Range("R2C1:R5C11"), 4, False) Cells(NextRow, 6) = TextCustomerOrderNumber.Text Cells(NextRow, 7) = TextDeliveryTimeCustomer.Text Cells(NextRow, 8) = TextAmount.Text Cells(NextRow, 9) = TextProducingWeek.Text |
Нужна помощь
Изменено: zeus12 - 25.03.2015 22:27:44