08-25-2006, 04:04 PM
I am unable to locate any help on the topic using the forum search. If anyone uses Excel spreadsheets for pricing operations, please let me know if there is another way to do this other than my earlier request.
What I am looking for is an operation that identifies a product name or number in any cell of the worksheet and jumps to the cell directly to the right and inputs the price I have attached to that product name or number.
Can anyone correct this?
Problem:
For Each c In Worksheets("Sheet1").Range("A1:K10000")
If c.Value = "Car 2" then
ActiveCell.Offset (0, 1).c.Value = "234"
End If
Next c
What I am looking for is an operation that identifies a product name or number in any cell of the worksheet and jumps to the cell directly to the right and inputs the price I have attached to that product name or number.
Can anyone correct this?
Problem:
For Each c In Worksheets("Sheet1").Range("A1:K10000")
If c.Value = "Car 2" then
ActiveCell.Offset (0, 1).c.Value = "234"
End If
Next c