Copying autofiltered data to a specific (changing) row using a macro
 

Hi,

I have a workbook contining a master spreadsheet, whenever a new row is
created in the master sheet I want to insert it into a specific (but
changing) row in one of the other spreadsheets in the workbook
depending on a value being entered in a specific column in the master
sheet.

I have used a macro with an autofilter function to do this, but it
overwrites data in the row I specify to copy to, is their any way I can
make it add the data to this row and automatically move all the other
data that follows down a row. I ame using the range.copy function