(Solved) – Excel Macro Range Update

(solved)-–-excel-macro-range-update

I have an excel workbook which includes the following –

  • Row 1 Border
  • Row 2 Column Header Group
  • Row 3 Column Header
  • Rows 4 – 29 are the data

  • Column C is a variable (Buy, Hold, Sell) Again C3 is the column Header.
  • Column O is the 5 Day Daily Percentage Change (O3 is the header)
  • Column U is the 5 Day Score (U3 is the header)

The first thing I want to do is set the values in C4 – C29 to Sell WHERE the values in O4 – O29 are less than 1.00

Next
Set the values in C4 – C29 to Sell where the values in C4 – C29 ARE NOT ‘Sell; AND O4 – O29 <= 2 Next Set the values in C4 - C29 to Buy where the values in C4 - C29 ARE NOT 'Sell; AND O4 - O29 > 3

Please, can you guide me on how to do this?

Thank you

Leave a Reply

Your email address will not be published. Required fields are marked *