excelhelper911
New Member
- Joined
- May 10, 2018
- Messages
- 2
I have two sheets in my workbook---I'm looking to scan the data in Sheet 1 and place it into specific sections (set end destination in Sheet 2).
I'm looking to take all of the rows in Sheet 1 that fall under a certain criteria and paste them into their respective section in sheet 2.
"If the cells in column 2 of Sheet1 begins with E*...
Paste all rows that meet this criteria beginning in row "9:9" of Sheet2"
Once done searching for the first criteria...then move onto the second criteria
Then...
"If the cells in column 2 of Sheet1 begins with F*...
Paste all rows that meet this criteria beginning in row "25:25" of Sheet2"
and so on until all of data from Sheet 1 has been sectioned into sheet 2.
Following this I have the VBA code to delete all blank rows in order to consolidate my data.
I'm looking to take all of the rows in Sheet 1 that fall under a certain criteria and paste them into their respective section in sheet 2.
"If the cells in column 2 of Sheet1 begins with E*...
Paste all rows that meet this criteria beginning in row "9:9" of Sheet2"
Once done searching for the first criteria...then move onto the second criteria
Then...
"If the cells in column 2 of Sheet1 begins with F*...
Paste all rows that meet this criteria beginning in row "25:25" of Sheet2"
and so on until all of data from Sheet 1 has been sectioned into sheet 2.
Following this I have the VBA code to delete all blank rows in order to consolidate my data.
