Excel 2007 VBA If then offset

Closed
TJ - May 10, 2010 at 02:54 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 15, 2010 at 04:09 PM
I have a sheet where the rows size varies and I am looking for code to lookup column F starting in row 3 to the bottom and if the cell has a "Q" then enter "QUOTE" in column AF in the same row.
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 10, 2010 at 03:08 PM
Why not write a formula in AF

=IF(F3<> "Q", "", "Quote") and drag this formula down
Tjones4852 Posts 11 Registration date Monday May 10, 2010 Status Member Last seen December 9, 2011
May 15, 2010 at 11:56 AM
Because AF contains data but blank if F = "Q" and it is part of a sheet set up macro so I need to find all the Q's in column F (dynamic range) and enter "QUOTE" in column AF
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 15, 2010 at 04:09 PM
Is it manually entered value in AF ? or is it a formula . If it is a formula then you can use

=IF(F3 ="Q", "Quote", << you old formula here>>)
0