Populating Multiple Columns and Rows based on number of sheets

hartjonathand

New Member
Joined
May 23, 2016
Messages
18
Hey guys,

I think I generally have an idea of what I'm doing on populating columns in multiple sheets, adding data from other sheets.

My question is related to being able to insert rows based on the number of worksheets in the workbook.

Thinking about this the process would be

Count the number of worksheets
For each worksheet i in workbook
add a row starting at row "a"
iterate until populated for first matrix

repeat for matrix below.

Thanks all.
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
64,093
Office Version
  1. 365
Platform
  1. Windows
Not entirely sure what you are after, but this will insert as many rows as there are sheets starting in row 2
VBA Code:
Sub hartjonathand()
   Rows(2).Resize(Worksheets.Count).Insert , xlDown
End Sub
 

Forum statistics

Threads
1,144,580
Messages
5,725,099
Members
422,590
Latest member
Mikeyyy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top