I have a worksheet called "Test Log" with a "Y" in column A - starting in row 5...(A5:A)
For as far down as the "Y" goes (but no further) I want to copy and paste the formula as VALUES in column E, again starting in row 5...I need the formula to stay in place for any rows that do not contain "Y" in column A for future calculations...
I would like to offset this by 6 columns, 12 times.
Can anybody help, I cant figure it out !!
Thank you for any advice in advance