My saga continues.
Still trying to clean up the mcaro I recorded.
In "COL D", I want to enter TEXT as "PAI",
then have it copied down to where the data ends in the adjacent Col "C".
How can I accomplish this?
Finally;
"R" lists my salesmans COMM Rate.
"O" lists the Sales for an item for the month.
From P2: where-ever the data ends in "O",
I need to start by taking R2*O2, and conyinue on down the line as far as the data entends in "O".
Can I do something like this:
Dim lastrow As Long
With ActiveSheet
.UsedRange
lastrow = .Cells.SpecialCells(xlCellTypeLastCell).Row
.Range(("P2:P" & lastrow)= "RC[-1]*[RC+2]"
End With
End Sub
Have a Great Day,
Zac
Still trying to clean up the mcaro I recorded.
In "COL D", I want to enter TEXT as "PAI",
then have it copied down to where the data ends in the adjacent Col "C".
How can I accomplish this?
Finally;
"R" lists my salesmans COMM Rate.
"O" lists the Sales for an item for the month.
From P2: where-ever the data ends in "O",
I need to start by taking R2*O2, and conyinue on down the line as far as the data entends in "O".
Can I do something like this:
Dim lastrow As Long
With ActiveSheet
.UsedRange
lastrow = .Cells.SpecialCells(xlCellTypeLastCell).Row
.Range(("P2:P" & lastrow)= "RC[-1]*[RC+2]"
End With
End Sub
Have a Great Day,
Zac