Hey Mark. When you're talking about AutoFill, that's a specific feature in Excel. I think what you mean to say is you want to copy the total or link the total value from that sheet to your summary sheet, is that correct? Can you show me some screenshots so I can see what you've got now? Black out any sensitive data, of course.

ok here are the pictures. In the first one you see the totals in blue along with the month that we choose is on the right side. I would like to like the totals to the one on the bottom photo to the month and have it fill in. As we choose the month on the first photo we can have it linked to the month on the second to fill in and keep track. How can we do this?

Just put a formula in the summary sheet that links to the cell in the first sheet. You can do it with a Copy, Paste Link.

Hi Richard, I did some research yesterday for several hours and after googling it I was able to find the correct coding for my project. Thanks.

Awesome.

Hi Richard and guys. After finding the formula and trying for several hours, now I need to find out how to keep the numbers constant across the row. The formula I am using is as follows. =IF((J1= Filters!B2), 'Monthly Totals'!I3,0). when this formula inserts the number and i go to the next month that number that just got inserted turns to 0. question how do i keep that number to stay the same when i choose another month. On this formula toward the end it says 'Monthly Totals'I3,0. The 0 at the end needs to be changed but to what? i am still researching, does anybody have any idea what to put to keep that number. Thanks.