Hi all,
I'm very new here and with VBA in general, so I need some assistance.
What I'm trying to do is take a spreadsheet with headings (not on row 1) that are also divided into types (meaning merged cells in column A that have basic headings as well, such as Cancel, Endorse, etc) and manipulate it so that I can maneuver each section into its own sheet and do counts of certain criteria in specific columns that I can have put into another workbook entirely in a table. Making the separate tabs may not be necessary, but it was my first idea. I was trying to think of some way to basically make it go "if this value is in Column A, select the section belonging to that word, copy/paste it over, and do the calculations".
Hopefully that made some semblance of sense. Anyone have any suggestions?
I'm very new here and with VBA in general, so I need some assistance.
What I'm trying to do is take a spreadsheet with headings (not on row 1) that are also divided into types (meaning merged cells in column A that have basic headings as well, such as Cancel, Endorse, etc) and manipulate it so that I can maneuver each section into its own sheet and do counts of certain criteria in specific columns that I can have put into another workbook entirely in a table. Making the separate tabs may not be necessary, but it was my first idea. I was trying to think of some way to basically make it go "if this value is in Column A, select the section belonging to that word, copy/paste it over, and do the calculations".
Hopefully that made some semblance of sense. Anyone have any suggestions?