Hello everyone,
Okay so I'm rather new to excel and slowly getting the hang of it. However I am LOVING the very little that I know about macros! I really want to learn more but I've been a little stuck for the last 2 days trying to make a macro that will be activated by a button. So here's my dilema:

For my tour operation I have a chart set up (range B6:R17) with formulas to calculate a final selling rate for excursions based on different values put in by a user. I want to be able to press a button above my chart that will, when pressed, make a copy of the same exact chart below the original (to a new range of B20:R31) The chart is found inside of a larger work "square" where other date is represented concerning the particular excursion, including the name of the excursion, ect..

So here's the tough part, the spread sheet is full of the same repeated work "square" being used for A LOT of other excursions and their data.

I would like, that when pressed, this button could also run a macro that would somehow create the space needed to fit the newly copied chart underneath the original work "square" without deleting the data already entered in the other work "squares" below. Maybe by creating more cells that would "shift down" the other work "squares"?

There's also one more thing.. Next to this button is an open cell (G4) where the user can enter a number representing the number of passengers that will be going on the excursion (important when making the calculation). The data in (G4) is copied and pasted over the data originally entered in the fist chart (E8) when the button is pressed and a copy is made.

The idea of having this button is to create a copy of the same chart to have a "side-by-side" (one below the other) comparison between the same excursion but with different prices based on the different number of passengers attending. This button would also have to be able to, when clicked a second time, copy again the same chart, but this time paste under the previously copied chart instead of directly under the work "square" as what would have happened the first time the button was pressed. I would like it to be able, in theory, to make as many copies as the number of times a user presses the button. haha.

I hope this makes sense and isn't too long.. I'm pretty sure it's possible I just can't seem to make the pieces fit together and some parts I have no idea what to do.

Anyway, thanks for reading and any tips would be greatly appreciated. I hope all the information is present if anyone wanted to take a stab at it, let me know. Thank you again!