Button to automatically change linked cells
Hi all,
I have a questionaire that populates the data on the next sheet (Sheet2). I
want to create a button that will change the linked cells automatically so
the next person to fill it in will be captured on a separate sheet (Sheet3,
then Sheet4 and so on). I have no idea where to start on this as I am a
numpty when it comes to code.
Hope you can help
Have a great Xmas all!!!
Thanks
Michael.
|