Hi
In the attached spreadsheet I have several columns of data that I want to concatenate into a results table. I'm able to do this using a formula in each of the results cells, but it's not prefect. The data in the input cells is moved up and down the various columns to make sure there are gaps between where the data is repeated (i.e Date 1/1 13 rows between appearing the first and second time. This is variable). The gap between data is variable and can be set by dragging the data up or down the column. (Data from only one of the input tables may appear in the left or right lane).
Here's the problem. If I drag and drop data the concatenate in the results gets corrupted and returns a "Ref". What I'd like to do is to do away with the concatenate formula and have a VBA code that works from a button, so that once the inputs have all been manually sorted, clicking the button will fill the results table.
The number of rows and input tables is variable.
I've looked at various ideas on-line but can't find anything that I understand enough to butcher to work for me!
Thanks in advance
Frankie.
Bookmarks