Multiple Main Function calling one sub function in different ranges

Hey all,
I am working on tidying up code finally!
I have a single data page (Sheet 4), with (e.g Rows 1-10 = Case 1, Rows 11-15 = Case 2, Rows 16-23 = Case 3).

Sheet 1 has button 1, Sheet 2 button 2, Sheet 3 button 3.

All three buttons need to take column A Sheet 4 -> Paste it in last column Sheet 5. But only for their range (sheet 1 button = case 1 etc).

Do I need to write 3 macros, exactly the same but with different ranges specified? Or can I have one macro that says "If button on sheet 1, then apply case 1. If button 2, apply case 2 etc).

In actuality there are going to be several sub functions to each button, each doing the same thing but for different ranges, so not writing the same code lots of times with different ranges would be good!

I can write all of the individual codes I need, just not sure how to call them as above.
I can't upload any example yet as I wanted to see how to structure this before starting to write it all

Hope this makes sense!
Luke

One way of many:

Please Login or Register  to view this content.