Hi there
I was wondering if someone could help.
I have a spreadsheet were the user will input solar radiation data. This data will have been collected on a particular date, but I don’t want the user to input the date manually , what I would like to do is for the user to input a start date and end date for the data and for excel to populate the date column based on this information.
For example if I have a months worth of hourly data from April to be entered into my spreadsheet. I want the user to enter in the start date of 1/4/2011 and the end date of 30/4/2011. And for excel to put 1/4/2011 in the first 24 cells, and then the 2/4/2011 in the next 24 cells and so on.
Does anybody know how I could achieve this / if it is even possible?
I don’t mind using VBA if this is the only way it can be achieved.
Thank you in advance
David
Bookmarks