How to copy a table multiple times in excel in a short time?

Question

How can i paste a table multiple times in a single click on excel? Like the table below. I want this table to be pasted multiple times in a single click as pasting more than 100 times can cause me a lot of time. If their as any way please guide me.



DATE ORDER #
MODEL CUTTER NAME
LEATHER SUPERVISOR
ARTICLE STITCHER NAME
COLOR SUPERVISOR
SIZE S FINISHING

Answer 1

Multiple Times Table

Answer 2

Click in the "Date order #"cell; Start recording a Macro, Type all the data in once, arrow to the next starting point, end the recording.

Now just hold down the macro key. Just watch the cell rows and stop after 600.



Even easier: highlight the list and one blank row and then use the auto fill handle, drag it down till the 600 row comes up.

Answer 3

1. Just create the normal table

2. Select the whole table & Copy it

3. Select the area for paste depending on your table size

(Suppose, your table has 4 columns & 11 rows and you want 4 tables more, then select 16 empty columns with the same 11 rows)

4. Just paste (CTRL + V)