HELP!!

I'm currently adapting a spreadsheet for work, that I need some help with.

Basically I'm creating a year to date spreadsheet showing our monthly performance I have a table with the months of the year, target, actual and running totals.

What I'm looking to do is enter a particular month in a box and have excel auto fill the target and running target box's .

I've tried allsorts but can't seem to crack it - anybody got any idea if this is possible.

the sheet is going to be used by other managers and whilst I could fill it in manually each month it would be easier if it would auto fill from the information that is already filled in every day.

Thanks in advance for anyone who has any idea.

I dont think you can do it with a normal macro, you will need to use a VB one. I dont know how though.

I dont think you can do it with a normal macro, you will need to use a VB one. I dont know how though.

That's what I was thinking, only my VB ain't that good - oh well no time like the present to learn I suppose!!

could you not use sumif statements?????

=SUMIF(OUTPUT!$D:$D,"FAI_HARDWARE-"&Daily!$C18,OUTPUT!$C:$C)

Not sure i understand what you fill in where and what you want to it to autofill.

Do you mean enter in the month and it just fill in the rest (as if copy and pasting)?

Could do this with a hidden worksheet that it gets the information from.

My VB has become a bit rusty! lol

HELP!!

I'm currently adapting a spreadsheet for work, that I need some help with.

Basically I'm creating a year to date spreadsheet showing our monthly performance I have a table with the months of the year, target, actual and running totals.

What I'm looking to do is enter a particular month in a box and have excel auto fill the target and running target box's .

I've tried allsorts but can't seem to crack it - anybody got any idea if this is possible.

the sheet is going to be used by other managers and whilst I could fill it in manually each month it would be easier if it would auto fill from the information that is already filled in every day.

Thanks in advance for anyone who has any idea.

If this is still an issue - I can help.

Please PM me if you need help - I can do both excel and VB so no problems there!

Hope this helps,

Rob