Hello,
I have a workbook with 120 tabs. Each tab has a different different name, but each tab has values in cells w12, x12, y12, z12, aa12 that i would like to get.
Essentially I am trying to create a summary sheet that has the sheet names in column A and then the corresponding values. it would look like this
[TABLE="width: 500"]
<tbody>[TR]
[TD]SHEET NAME[/TD]
[TD]10TH%[/TD]
[TD]25TH%[/TD]
[TD]Median[/TD]
[TD]75th%[/TD]
[TD]90th%[/TD]
[/TR]
[TR]
[TD]cardiology[/TD]
[TD]cell w12[/TD]
[TD]cell x12[/TD]
[TD]celly12[/TD]
[TD]cell z12[/TD]
[TD]cell aa12[/TD]
[/TR]
[TR]
[TD]dermatology[/TD]
[TD]cell w12[/TD]
[TD]cell x12[/TD]
[TD]cell y12[/TD]
[TD]cell z12[/TD]
[TD]cell aa12[/TD]
[/TR]
[TR]
[TD]emergency medicine[/TD]
[TD]cell w12[/TD]
[TD]cell x12[/TD]
[TD]cell y12[/TD]
[TD]cell z12[/TD]
[TD]cell aa12[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I was hoping there was a way to use VBA to first list out all of the sheet names in column A and then go to each sheet and pull the values in cells w12, x12, y12, z12, and aa12. Is this possible? Thanks!
I have a workbook with 120 tabs. Each tab has a different different name, but each tab has values in cells w12, x12, y12, z12, aa12 that i would like to get.
Essentially I am trying to create a summary sheet that has the sheet names in column A and then the corresponding values. it would look like this
[TABLE="width: 500"]
<tbody>[TR]
[TD]SHEET NAME[/TD]
[TD]10TH%[/TD]
[TD]25TH%[/TD]
[TD]Median[/TD]
[TD]75th%[/TD]
[TD]90th%[/TD]
[/TR]
[TR]
[TD]cardiology[/TD]
[TD]cell w12[/TD]
[TD]cell x12[/TD]
[TD]celly12[/TD]
[TD]cell z12[/TD]
[TD]cell aa12[/TD]
[/TR]
[TR]
[TD]dermatology[/TD]
[TD]cell w12[/TD]
[TD]cell x12[/TD]
[TD]cell y12[/TD]
[TD]cell z12[/TD]
[TD]cell aa12[/TD]
[/TR]
[TR]
[TD]emergency medicine[/TD]
[TD]cell w12[/TD]
[TD]cell x12[/TD]
[TD]cell y12[/TD]
[TD]cell z12[/TD]
[TD]cell aa12[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I was hoping there was a way to use VBA to first list out all of the sheet names in column A and then go to each sheet and pull the values in cells w12, x12, y12, z12, and aa12. Is this possible? Thanks!