Posts by reddale

  • Find data in a column in a sheet based on data in a cell on another sheet

    Hello


    First post here.


    I am trying to use VBA to find a cell in a column that contains the same data as entered in a cell on another sheet. Then select that cell.


    Example might be. Find the value that is in cell a1 on Sheet 1, in column b on Sheet 2, then select that cell in column b on Sheet 2.


    Column B will contain some empty cells and some with data.


    Once the cell in column b on sheet 2 is found, I want select more cells to the right and paste formulas into them, but I think I've got that sorted. Just need to be able to find the cell first. I'm going to fire the search by having the user click a button on sheet 1. The user doesn't need to see sheet 2.


    Thanks