From your description, you must be using a macro when 'the info goes to the
respective individual page'.

Tell us how the information 'goes' to the respective page -- either the formula
or the macro, and we'll help you figure out how to fix it.

--
Regards,
Fred


"kdmarvin" <u32449@uwe wrote in message news:6f1ee83172748@uwe...
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?