Creating a list for data entry based on variables (Assets)

Hi All,

Just wondering if I could get some suggestions as to how to automate what I am trying to do here, preferebly without using Macros. Based on a list of assets and assuming two shifts (Day and Night), on a seperate sheet I would like to generate a list for data entry to be made. This will be done on a new sheet on a month by month basis and thus I would also like the sheet to generate the list for the entirity of the month, which will vary based on the number of days in said month, which I wish it to determine from the start of month date that is entered at the top of the sheet. Please see my attached example which I have started manually enterring. I wish to do this for the entirity of the month. As Asset ID's will often change month to month, as well as the length of the month, this can be a tedious task and Im not happy that a simple copy and paste will do between months.

Any help is much appreciated and I hope this isnt too confusing.

Thankyou in advance,

Regards,
Ben

Example One.xlsx

Without sounding rude, I have no idea how that is supposed to help me. I am not after a drop down list, rather I wish to create a large blank table ahead of everymonth for data entry then to be completed in the collums adjacent to the date, asset ID and Shift. This data will be entered on a day by day basis once the time sheets for the employer operating that asset has been recieved. However, the data entry is not important to this problem. What is important is that for each month I need to create a new base 'data' sheet that already has all the shifts for each piece of equipment, listed out, as I have manually shown in my example for the first three days of the month. The reason I want this automated is it will save alot of time. The reason I cant just copy and paste each month is predominantly the asset IDs will change from month to month, sometimes increase in numbers, sometimes decrease, sometimes be completely different, thus I want the 'data' sheet to be generated from the list of assets I have on the first sheet ('Assets').

I would be content if this problem could be solved using Macros, since this post has now been moved to the Macro and VBA forum and since it is looking like this is the only potential way to find a solution to my problem. Unfortunately I am not very familiar with Macros other than hitting the record button and maybe dragging some data into the spreadsheet, thus any instructions will have to be pretty much written in layman terms for myself to understand.

Any help would be appreciated!

Cheers,

Ben

I am aware that a Macro will be the best way, and I have tried recording this myself but as the length of the list varies and so does the length of each month I cannot get this to work correctly for me. It needs to be something where I can fill out the list of asset ID's for the month, enter the date for the first day of the month, hit a button and voila!