Extracting formulas rather than values

When I use Advance Filter to filter a list and opt to copy it to a different location on the spreadsheet, Excel seems to copy values only, not any of the formulas in the original list. I want to send the filtered lists to various departments and have them insert and/or edit their own data. When they do this, the cells that should have formulas in them now have the values from the original list, and the spreadsheet returns incorrect figures in those cells.
Is there any way to copy the filtered list with the formulas intact? After I do the copy, I can always do a macro to copy the formulas from the original list to the filtered list, but this is cumbersome, inefficient and lacking in grace.