Forum Discussion

IT_Guy_Anton's avatar
IT_Guy_Anton
Copper Contributor
Mar 04, 2020

Duplicating tables depending on the number in a cell

Hello guys,

 

is there any formula to duplicate a table times the number in a cell automatically?

Example: I got the information that there exist 3 external networks. So i put in cell E7 the number "3".

And this should copy the table 3 times, like making a subgroup 3 times.

1 Reply

  • Hi IT_Guy_Anton

     

    a small sample file will be helpful to guide the best solution. make sure to please show your desired result.

     

    Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert | www.ExcelExciting.com

    If you find the above solution resolved your query don't forget mark as Official Answer.