Good Day!
I am looking to find out a way to create tabs at the bottom of a workbook based on information in a cell without simply copying and pasting and creating my own tabs.
For example, in the document attached I want to create a tab for:
Note 1 - Tab Name at the bottom - Column A-D in the Tab - Info pulled from Row 2-89
Note 2 - Tab Name at the bottom - Column A-D in the Tab - Info pulled from 90-189
Note 3 etc
Notes"
The data would be final when I create the final workbook.
The amount of Columns is TBD
The amount of Rows for Note 1, Note 2 have may not match what I have here when the final data is ready
I am looking to find out a way to create tabs at the bottom of a workbook based on information in a cell without simply copying and pasting and creating my own tabs.
For example, in the document attached I want to create a tab for:
Note 1 - Tab Name at the bottom - Column A-D in the Tab - Info pulled from Row 2-89
Note 2 - Tab Name at the bottom - Column A-D in the Tab - Info pulled from 90-189
Note 3 etc
Notes"
The data would be final when I create the final workbook.
The amount of Columns is TBD
The amount of Rows for Note 1, Note 2 have may not match what I have here when the final data is ready