Creating new table with macro

Hello

i need to create a macro that will make new day table.
for example:

i have a table for day 1 and when i press on a button it will make a new table for day 2 below it and so on.
however if the table contain a data it will not copy the data and create only clean table.

Thanks for your help!

Hi

What do you mean using the word "table"? If your data are in a real table, this expanding itself as you add data in it.

Thanks for answering.

i'll explain myself again.

i have table with data in it. i want to create a button or macro or whatever that when i press it, it will create a new clean table without the data similar in the style to the table b4 and so on.
i made this code which copy the cells to other location.

Please Login or Register  to view this content.

but there's 2 problem with it:
1. it only copy 1 time to one location and i want that the the range cell it will copy will change every time new table is created.
2. if there's data in the table it will copy the the table with the data.

edit:
ok i added that it clears the data, you can see the example in the attached file.
now how do i make it change the destination of the range when you click the button, and make new button below it with the same option.

I am sure that VBA experts that are online, have a better sugestion but until then here is a suggestion.

Please Login or Register  to view this content.

Not sure whay you mean by this "how to do this and keep the style in those cells?"

In Excel editions before 2007 the file was saved as xls and when a macro was in that workbook, a notification was appeared when you tried to open that workbook.

Ok. Use this.

Please Login or Register  to view this content.

Run this one.

Please Login or Register  to view this content.

Upload a worksheet showing what you mean.

The code count and find which is the last row in column B which has data, then skip a row and create a new table to the next empty area. So needs the last row in column B of the last table to have data in it.

ok now there are still 2 problems..
doesnt copy the style of the cells.
and in row 2 of the table it doesnt copy the border.

and how can i change the button position every time i click on it?
if the button is below the table, after clicking on it and creating new table i want the button to be below the new table.

nvm, i manage to do it myself

Please Login or Register  to view this content.

with the button changing his position after every click.

Thanks anyways and big thank you for your help!