Instead of "Deleted_FTE!$E$1:$E$2" create a Dynamic Range Name In this case
say DelFTE1 using the Formula =Offset($E$1,0,0,Counta($E:$E),1)
Instead of "Deleted_FTE!$E$1:$E$2" create a Dynamic Range Name In this case
say DelFTE1 using the Formula =Offset($E$1,0,0,Counta($E:$E),1)
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
Reply With Quote