FrEaK_aCcIdEnT
Board Regular
- Joined
- May 1, 2012
- Messages
- 104
- Office Version
- 365
- Platform
- Windows
- Web
I have been trying to figure this out. I need to search a spreadsheet for a record. Then for every cell that it find with the record, offset to locate the corresponding data, Then repeat until it has found all records and combine them all into one cell as the output.
Searching, offset, setting the variable for a single record, is not problem. Just never tried to put multiple records together before.
Search for all "1" values and every record that matches value & char(10) & value. Could be 1 hit, could be 20 hits. Just need them all to end up in the same cell with a page break. Any takers?![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
Searching, offset, setting the variable for a single record, is not problem. Just never tried to put multiple records together before.
Search for all "1" values and every record that matches value & char(10) & value. Could be 1 hit, could be 20 hits. Just need them all to end up in the same cell with a page break. Any takers?