Populate information into continuous list on another Sheet

EAATC

New Member
Joined
Oct 16, 2017
Messages
3
I have a document I am trying to create and I need your help yet again to look good! :laugh:

What I am trying to accomplish is a user select a button or mark an "x" in a box in the column of O, P, and or Q.
Each column (O,P,Q) would have their own associated sheet to populate. So If I select O6, I would like the data in B6 to populate on the associated "O page" Subsequently, if P6 is selected The data in B6 would populate on the associated "P Page", the same would hold true for Q.

Here is the important part, the info would need to populate into one list. So if I select O6 thru O32, then all the associated tasks listed in B6 thru B32 would enter into a continuous list on "O page E3 cell"

Is this possible to do, if so is it possible without a macro?

Thanks in advance for any help.
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Forum statistics

Threads
1,223,904
Messages
6,175,295
Members
452,633
Latest member
DougMo

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
Back
Top