Here's the problem


I have an input page, I input all the clients details, age, address etc - This works
on drop down menu's etc in areas

Next I have macro where you can move forward back between pages..

The next pages are days of the week Mon / Tues and so on they are all the same
on these pages you insert data from drop down menu's etc and on each of the days
are totals for each day

Now there is an output page this outputs all the details of the totals

Runs by simple = click on the day of the week, click on the total and hit 'enter'


The problem I am having is I need to add multiple clients and output their details...

Now I have created another page after Output where I run a macro where it adds
a new row and then paste's the clients name, total for the week

Now that works fine but when I reset the Input etc that page resets so I want to
know how to sort of lock that data once its on that page...

That page lists all the clients details and its for multiple clients

I'm thinking this makes no sense..lol Hopefully someone understand sit as I do and can help.