Equipment Schedule

[crburke92]

I've been looking at a few different ways of doing this, hoping someone could possibly shed some light on what may be the easiest way. I'm trying to build a schedule for my offices equipment that goes out into the field (We have about 70 or so pieces of gear to log). Gear to be listed down the rows, dates to be the columns.

Sheet1 to be the schedule
Sheet2 to be a form you fill in

So sheet2, someone fills in the blanks. Gear to be used(dropdowns maybe, to make the reference to sheet1 easier?) start and end dates, and then maybe some text that fills in for a job number or comments. When a button is pushed, it finds the intersect point on sheet1 between the selected dates and the gear used, highlights the cells and inserts the comments into the first cell, then clears the information filled in on sheet2 so it can be filled in again.

Not sure if there's an easier way to do this through formatting or VBA, any help is much appreciated

 

[crburke92]

Holy man.. I see what you did there, way tidier than how I had started it. That works great mumps, thanks for doing that!

 

[mumps]

My pleasure.

 

[mumps]

I forgot the part that clear Sheet2 data. Put this line of code at the end of the macro:

Range("B7:G11").ClearContents

right below

Next rng

 

[crburke92]

Haha funny you mentioned that, Already put that part in, as well as changed to color index to a cell reference, to allow for different colors based on the person taking the gear

Thanks again!!

 

[mumps]

You are very welcome.