conditional copy/paste

Hi,
I created a template spreadsheet with a macro that is supposed to take individual patient sample data from one sheet and paste it in a certain way in the other sheets. Each row has a sample name/info and a numerical code (1,2,3), which will be the basis of how each sample is treated. The codes and positions of the codes will change each time I run the macro. I made a macro that I thought was doing this, but it still chooses the same original rows (not based on only what is active after applying the filter) that were selected during the recording of the macro. Basically, I need to filter the sample info by code and only copy the material filtered, which will change each time. Then, in one of the sheets, I need to go to the next blank cell and paste the info there. How can I do this?
Thanks in advance!
Jenny

If you recorded your macro you may have a line which selects a defined range of cells followed by a Selection.Copy line.

If you remove the defined range line and leave the Selection.Copy line, you should have something more generic.