How to populate sheets from a specified set of cells..

N

neilcarden

Hi all, I'm a bit new to this function (possibly a macro). I am creating
a monthly report for work based around KPI's for our business. In the
same workbook is a 'Year To Date' sheet. I have a sheet named 'Monthly
Data' which has various cells for data. I want to set up a button, so
when I input data for April on the 'Monthly Data' sheet, and press it
the data populates to the cells under that month in the 'Year to date'
sheet. And then in May I can overwrite the data on the 'Monthly Data'
sheet and press the button again to populate the cells under May in the
'Year to Date' sheet. I obviously need some kind of drop down box to
specify which month I need to populate...

If someone could show me a basic way of maybe doing a couple of cells,
so I can see the workings of it, I'll be able to configure myself, or
if anyone knows any online resources?

Thanks
Neil
 
Top