write to col. based on criteria (value in a cell)

  • Hi guys & girls
    Had great response from last query which was to write to a specific column from a cell in the same row after evaluating a column of data ;-



    Value of col.5 was written to col. 9 same row.
    This works well but limits 'write' to a single specified column.
    Now I want to be able to do the same thing but write to a colum based on 'value of another cell' - actually a value located using 'match'.
    cheers

  • Code Tags Added
    Your post does not comply with our Forum RULES. Use code tags around code.


    Posting code between

    Code

    tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.


    Highlight your code and click the # icon at the top of your post window.


    (I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)