I have data in cells A4, B4, D4 and E4 and a set of "selector" cells in P8-S8 on the same worksheet. What I would like to happen is if the user selects P8 (by entering an 'x') then cell G8 would equal the value of A4. If the user also selects cell Q8 then the value of cells A4 & B4 are combined within cell G8. This would apply for any combination of the user selecting cells P8:S8
There will also be a hyphen that needs to be included between the values of data from cells A4, B4, D4 and E4.
I think an example will make it much easier to understand so a sample file is attached.
Bookmarks