Formula help

Copper Contributor

I need help to create a formula.

 

I'm new to this, so i apologize in advance if my wordings are off. Any help will be appreciated.

 

Here is what i need. I attached a document

 

As check marks are put into cells from the first page, names  should then populate the cells to the corresponding sheets under the AM driver or PM driver columns in the second page. Keep in mind, every sheet is separate and are in Ledger form. 

 

Also, which will be easier, keeping every sheet separate or have all sheets under one workbook

 

 

 

 

5 Replies
I would indubitably be easier to suggest an appropriate formula if you attach your sample Excel, rather than Word, file.

@aisa313 

Hi

There are different ways of creating a YES/NO field, or a Checked?Unchecked box or a CheckMark/ XMark options.

I explained all these methods in details in the following video Tutorials:

 

Creating a Check Mark or an X mark using Icon Sets

https://www.youtube.com/watch?v=qKfk4wdtDTc

 

Using Combo Box To Create a Check Mark or an X Mark

https://www.youtube.com/watch?v=837XYZApm1s

 

Excel Calculations Using a Check Box

https://www.youtube.com/watch?v=qctkwUnle4M

 

Hope that helps

Nabil Mourad

Here it is @Twifoo. Hope this makes it easier to understand what i need done. 

Sorry@Twifoo , here's the attachment

Thank you @nabilmourad, the videos help with some of the issues i'm trying to resolve which i've used already. However, still need to figure out how to populate the names from the weekly schedule to the corresponding daily schedules and shifts depending on which cells has check marks on the weekly schedule.