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 X12
.
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.
=IF(OFFSET(Form!$A$1,ROW(C14)-1,COLUMN(C14)-1)=0,"",OFFSET(Form!$A$1,ROW(C14)-1,COLUMN(C14)-1))
to mirror my new sheet as the old one. How can I delete the rows with anything but "X8"?