Linking information from worksheet to worksheet when a checkbox is checked

**Roads** · 09-04-2014, 03:25 AM

Good day,

I am new to this Forum, I have a task which I can not resolve.

On one sheet, sheet 1, I have a requisition/order form and another sheet I have the descriptions of a list of materials I wish to order. Each item of material has a check box next to it.Now the tricky part, I am trying to make the two sheets link so that when I select a check box, it must pick up what I have checked in sheet 2 in sheet 1 in the order form with no spacing between the items. I have attached a sheet with what I'm trying to achieve. any help would be greatly appreciated.

Thank you

**oeldere** · 09-04-2014, 03:39 AM

Is there a reason you can't put the two files in 1 file.

You can store the information on two tabs.

That will make it much easier to handle.

**Roads** · 09-04-2014, 03:44 AM

Sorry the first file is to be ignored, you will see on the second file there are two tabs, 1- Requisition, 2- trunking. I need these two to link with description I gave in my first thread