i am struggling with creating a function in excel.... i am creating a requirements document. i have my master list of requirements in worksheet1. i am creating additional worksheets for each project i am creating under the general program (worksheet2, worksheet3, etc). i need to copy all applicable requirements (full rows) from worksheet1 to the applicable additional worksheet, based on search criteria (ie, data in column B of worksheet1 = "1234", so paste that row here in worksheet2) as part of the traceability.
for example, all rows in the 'Master List' worksheet whose column heading Sub-Category = "Activate Account" should appear on the 'Activate Account' worksheet. i would like to use a formula so that the 'Activate Account' worksheet automatically finds all applicable rows in the 'Master List' worksheet, and pastes them into the 'Activate Account' worksheet (the full row). i would like each row to be automatically added to 'Activate Account' when i add a new applicable row to 'Master List', and any changes made to existing rows on 'Master List' should appear on 'Activate Account'.
playing with VLOOKUP has allowed me to copy over some fields, with automatic updates, but not get a full row to come over, and i cannot determine how it should search the whole sheet to return all rows i want.
is this possible???
Bookmarks