Equipment Schedule

crburke92

New Member
Joined
Feb 5, 2019
Messages
45
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 :)
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

mumps

Well-known Member
Joined
Apr 11, 2012
Messages
10,311
A macro would be able to do this for you but without something to work on, it's difficult to help. Perhaps you could design a workbook with the 2 sheets formatted the way you described and enter some data (gear and dates in sheet1). Then you could post a screen shot of what your data looks like in both sheets? Section B at this link has instructions on how to post a screen shot: https://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html Alternately, you could upload a copy of your file to a free site such as www.box.com. or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Include a detailed explanation of what you would like to do referring to specific cells, rows, columns and worksheets. If the workbook contains confidential information, you could replace it with generic data.
 

crburke92

New Member
Joined
Feb 5, 2019
Messages
45
I have the Mr.Excel HTML Maker downloaded and the add-in on my ribbon, but when I select my custom range to print and hit ok, nothing ends up happening.
 

mumps

Well-known Member
Joined
Apr 11, 2012
Messages
10,311
We're almost there! The link you posted takes me to the DropBox home page. I need the direct link to the file. Mark the file for sharing and you will be given a link to the file. Copy/paste the link here.
 

mumps

Well-known Member
Joined
Apr 11, 2012
Messages
10,311
Thank you for the file. In Sheet2 you have chosen all the products listed in Sheet1 which means that all the cells for all the products between Jan. 1 and Jan. 5 would be highlighted. Is this correct? Also, will all the values in column B of Sheet1 always be unique, in other words no duplicates?
 

crburke92

New Member
Joined
Feb 5, 2019
Messages
45
For sheet1, yes, those will always be unique. I split the equipment name and its "EQ ID" because it will likely be easier to reference just that number as opposed to the entire name. Also yes for sheet2, the idea is to have an easy way of selecting all of the gear required and the dates required to then transfer over to sheet1.

I've been reading more and more into VBA and have made some pretty effective sheets for my company, but my background is not code so its usually messy/takes me awhile to get there haha. Its been fun though!
 

mumps

Well-known Member
Joined
Apr 11, 2012
Messages
10,311
Click here to download your file. I have added drop down lists in Sheet2. Just click the button.
 

Watch MrExcel Video

Forum statistics

Threads
1,130,112
Messages
5,640,173
Members
417,129
Latest member
geekzilla

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top