Forum Discussion
automatically duplicate/cop data from a shared worksheet to my own
THANK YOU!! I am sooooo new to all of this Excel and Google Worksheet world... FOR THE RECORD, I DO use Google Sheets, but figured I'd post here as well to further my reach in assistance. Backgroun...
Open both workbooks.
Copy the header row (presumably row 1) from the team workbook to your personal workbook.
Enter the following formula in A2 in your personal workbook:
=FILTER('[team workbook name]team worksheet name'!A2:Z1000, '[team workbook name]team worksheet name'!A2:A1000="JC". "No Data")
Substitute the real names of the team workbook and the team worksheet, and adjust the ranges as needed, then confirm the formula.
The result should spill to as many rows as needed.
Switch to the team workbook and close it.
Excel will automatically add the path of the team workbook to your formula.
Save your personal workbook.