Posts by reddale


    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.