Hello,
I would like to build concatenate function using buttons with assigned macros:
1)
I create button called "concatenate start" and want to assign to it a macro that
send value to any cell I select equals to =concatenate(
2) next buttons after click should add remaining value to =concatenate function i.e. Main Category button -> =concatenate("Main Category"
3) next button after click add semicolon in active cell -> =concatenate("Main Category";
and so on.
In general how can I build =concenation function in any selected cell by clicking buttons which adding values to other values in this cell.
I have many rows with data and it is easier to click buttons than coping/pasting data
29547ic.jpg
Bookmarks