For the sake of expediency let's say I have 2 worksheets. 1 is the master
sheet that I use for data input on a monthly basis. #2 would be an individual
sheet that a line on #1 refers to. Each month I enter data into 7 cells in a
row on sheet 1 and the info goes to the respective individual page( in this
case, page 2)that has an equal 7 cells in a row. When I enter data each
following month it enters into the 7 cells only the next row down to show the
info for that month. All works well except when I enter data into the cells
for the following month, it deletes the data from the month before and enters
the new data in that months' cells too. How do I get it to enter in this
month yet not change the month before?