I have a sheet with certain data arranged like this:
X8 - something - something2 X12 - somethingelse - asdfg X8 - asft - sastaryraavt X8 - random - random2
I need to extract only and all of the rows labeled
X8 to another sheet inside the Excel spreadsheet. So for the above example, the second sheet would look exactly the same but would be missing the 2nd row labeled
How would one go about doing this?
EDIT: I would like it to be more like a function and not require copy-and-paste or such. For example, if one value is changed in the parent spreadsheet, say the "something" in the first X8 row, the change should also automatically mirror over to the child spreadsheet (the one containing only X8 rows).
EDIT 2: I just figured out how to mirror my parent sheet to the new sheet using
=IF(OFFSET(Form!$A$1,ROW(C14)-1,COLUMN(C14)-1)=0,"",OFFSET(Form!$A$1,ROW(C14)-1,COLUMN(C14)-1)). I'm still confused on how to delete rows (like not just make empty, completely delete) that contain a certain word, say,
X12. Additionally, I'm using Google Spreadsheets so I don't think I can input code like
Sub etc and am relying only on native formulas.