There is a feature called Record Macro that will create a macro for you. Start recording yourself using the Fill Series function and then you should be able to run it over to duplicate what you performed on the worksheet.