marigold322
New Member
- Joined
- Mar 9, 2023
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
Hi there, looking for help to come up with some VBA code or even if someone could advise how this can be done with formulas if that is possible to assist in a data entry/retrieval model that automates the following process...
Info: We have a workbook with over a dozen sheets that contains individual data sets - they are not organized in any tables, and each sheet contains varying amounts of rows
some sheets contain a "communitymodifier" and we are trying to collect all of them, including some relevant info from that row, into a separate sheet (in same book).
- Search within each sheet of the workbook for cells containing text "CommunityModifier"
- For any cells that contain above text, return specific columns of data into a separate sheet
Any solutions or advice is appreciated, this is a large workbook and very labour intensive.
Info: We have a workbook with over a dozen sheets that contains individual data sets - they are not organized in any tables, and each sheet contains varying amounts of rows
some sheets contain a "communitymodifier" and we are trying to collect all of them, including some relevant info from that row, into a separate sheet (in same book).
- Search within each sheet of the workbook for cells containing text "CommunityModifier"
- For any cells that contain above text, return specific columns of data into a separate sheet
Any solutions or advice is appreciated, this is a large workbook and very labour intensive.