Button to automatically change linked cells

M

Michael B

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy a formula 3
Change event code Find .Activate does not activate Target.value 4
Search an array of sheets for an array of numbers & return count of numbers 11
Converting URLs in comments to Markdown-formatted links 2
Please help with Custom Views 0
External cell reference between two excel worksheets both in One Drive 0
Adding cells from different sheets of same workbook 2
Macro to change the column references automatically 2

Top