Hello Everyone,
I am definitely not well versed in the awesomeness that is Excel. I have seen many people on here write formulas that work magic and I am in need of that expertise.
I am trying to write a formula that will copy specific cells from one sheet to another. For example: if I have a column that has multiple cells that are identical, I would like to copy that entire row (or even better, certain cells in that row) to another sheet. I have attached an example to hopefully make things more clear.
THANKS SO MUCH!!!
A specific example using the info below would be this:
[TABLE="width: 808"]
<tbody>[TR]
[TD]Initials[/TD]
[TD]Status[/TD]
[TD]Room[/TD]
[TD]Patient[/TD]
[TD]Procedure[/TD]
[TD]POD #[/TD]
[TD]Physician[/TD]
[TD]Notes[/TD]
[/TR]
[TR]
[TD]WLW[/TD]
[TD]DC[/TD]
[TD]250[/TD]
[TD]Doe, Jane[/TD]
[TD]SBO[/TD]
[TD]7[/TD]
[TD]Smith[/TD]
[TD][/TD]
[/TR]
[TR]
[TD] JVL[/TD]
[TD][/TD]
[TD]300[/TD]
[TD]Doe, John[/TD]
[TD]Lap Chole[/TD]
[TD]1[/TD]
[TD]Smith[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WLW[/TD]
[TD][/TD]
[TD]350[/TD]
[TD]Mouse, Minnie[/TD]
[TD]RIH[/TD]
[TD]1[/TD]
[TD]Smith[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]JVL[/TD]
[TD]New[/TD]
[TD]400[/TD]
[TD]Mouse, Mickey[/TD]
[TD]Lap Appy[/TD]
[TD]1[/TD]
[TD]Smith[/TD]
[TD](+) N/D (-) Fever, Vomit[/TD]
[/TR]
[TR]
[TD]MAB[/TD]
[TD][/TD]
[TD]450[/TD]
[TD]Duck, Donald[/TD]
[TD]Bilat IH[/TD]
[TD]1[/TD]
[TD]Smith[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I am definitely not well versed in the awesomeness that is Excel. I have seen many people on here write formulas that work magic and I am in need of that expertise.
I am trying to write a formula that will copy specific cells from one sheet to another. For example: if I have a column that has multiple cells that are identical, I would like to copy that entire row (or even better, certain cells in that row) to another sheet. I have attached an example to hopefully make things more clear.
THANKS SO MUCH!!!

A specific example using the info below would be this:
- This example sheet is B5:B36, so the data starts at B6. The formula will be looking at the "Initials" column to know what row to copy and paste into the new sheet.
- The example sheet below is "sheet1" and has information to be copied and pasted into different sheets, e.g. "sheet2", "sheet3", etc
- All rows that start with "WLW" will be copied to "sheet2"; whereas, all rows that start with "JVL" will be copied to "sheet3" ***Ideally, I would like that only information from columns "initials", "patient", and "procedure" to be copied to the new sheet.*** Not sure if this is too difficult though...if it is, the entire row will work well enough.
- In the end, there will be separate sheets for each set of initials. This way all of the row information corresponding to those initials from "sheet1" will be collected in a separate sheet, e.g. "sheet2" for "WLW" and "sheet3" for "JVL".
- Also, I am hoping that I can use these formulas in Google Sheets (in addition to Excel). I am trying to make information available real-time.
[TABLE="width: 808"]
<tbody>[TR]
[TD]Initials[/TD]
[TD]Status[/TD]
[TD]Room[/TD]
[TD]Patient[/TD]
[TD]Procedure[/TD]
[TD]POD #[/TD]
[TD]Physician[/TD]
[TD]Notes[/TD]
[/TR]
[TR]
[TD]WLW[/TD]
[TD]DC[/TD]
[TD]250[/TD]
[TD]Doe, Jane[/TD]
[TD]SBO[/TD]
[TD]7[/TD]
[TD]Smith[/TD]
[TD][/TD]
[/TR]
[TR]
[TD] JVL[/TD]
[TD][/TD]
[TD]300[/TD]
[TD]Doe, John[/TD]
[TD]Lap Chole[/TD]
[TD]1[/TD]
[TD]Smith[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]WLW[/TD]
[TD][/TD]
[TD]350[/TD]
[TD]Mouse, Minnie[/TD]
[TD]RIH[/TD]
[TD]1[/TD]
[TD]Smith[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]JVL[/TD]
[TD]New[/TD]
[TD]400[/TD]
[TD]Mouse, Mickey[/TD]
[TD]Lap Appy[/TD]
[TD]1[/TD]
[TD]Smith[/TD]
[TD](+) N/D (-) Fever, Vomit[/TD]
[/TR]
[TR]
[TD]MAB[/TD]
[TD][/TD]
[TD]450[/TD]
[TD]Duck, Donald[/TD]
[TD]Bilat IH[/TD]
[TD]1[/TD]
[TD]Smith[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]