Hi -
I have a workbook with two worksheets. My second worksheet, "Scoresheet", has many cells that grab information from cells in the first worksheet, "Lineups". All of the information that is grabbed from "Lineups" is in row 2. I would like to be able to delete that row 2 (after printing "Lineups") and have "Scoresheet" update and grab information from the new row 2 in "Lineups". I would then continue this process, continually erasing that row two, having the other rows move up, and so on.
This is not working, as I just get #REF! error messages. Seems like an easy thing to do, but I can't figure it out. Can anyone please help me? Thanks in advance.
Jack
I have a workbook with two worksheets. My second worksheet, "Scoresheet", has many cells that grab information from cells in the first worksheet, "Lineups". All of the information that is grabbed from "Lineups" is in row 2. I would like to be able to delete that row 2 (after printing "Lineups") and have "Scoresheet" update and grab information from the new row 2 in "Lineups". I would then continue this process, continually erasing that row two, having the other rows move up, and so on.
This is not working, as I just get #REF! error messages. Seems like an easy thing to do, but I can't figure it out. Can anyone please help me? Thanks in advance.
Jack
