Hi all, complete newb to the forum and was wondering if I could get some help with a VB
I have a multiple tabbed spreadsheet (Sunday-Saturday and a few others that I do not need this VB to run on)
On each of Sun-Sat tabs, I have values in A1:A150(actually, it's all formulas pulled from another tab); and the main data is in B4:CS150
What I would like to do is:
When the value in any Cell A1:A150 = "UNFILLED" I need to have all cells in that row that = "1" change to "M"
I've searched like crazy and all I seem to find is conditional formatting, and have about hit my wits end......
Thanks So much for any assistance!
I have a multiple tabbed spreadsheet (Sunday-Saturday and a few others that I do not need this VB to run on)
On each of Sun-Sat tabs, I have values in A1:A150(actually, it's all formulas pulled from another tab); and the main data is in B4:CS150
What I would like to do is:
When the value in any Cell A1:A150 = "UNFILLED" I need to have all cells in that row that = "1" change to "M"
I've searched like crazy and all I seem to find is conditional formatting, and have about hit my wits end......
Thanks So much for any assistance!