Victtor
Board Regular
- Joined
- Jan 4, 2007
- Messages
- 170
- Office Version
- 365
- Platform
- Windows
What I need is a formula (or code) that looks for data in column A between two events. (a start event and a stop event)
find the FIRST blank cell in column A. count 5 rows down from this (START EVENT) and grab this data on that entire row and each following row until it reaches the row with TOTAL ITEMS on it (STOP EVENT).
Then repeat the process until it reaches 2 consecutive blank cells, then end program.
blank cell
header
blank cell
hide detail
customer
DATA (start with this row)
DATA
DATA
DATA
total items (STOP BEFORE THIS ROW)
Paste this data in a new sheet.
header
data
data
data
header
data
data
data
etc..
find the FIRST blank cell in column A. count 5 rows down from this (START EVENT) and grab this data on that entire row and each following row until it reaches the row with TOTAL ITEMS on it (STOP EVENT).
Then repeat the process until it reaches 2 consecutive blank cells, then end program.
blank cell
header
blank cell
hide detail
customer
DATA (start with this row)
DATA
DATA
DATA
total items (STOP BEFORE THIS ROW)
Paste this data in a new sheet.
header
data
data
data
header
data
data
data
etc..