Automatically copy multiple cell contents into one single cell

[CAMARD2]

Hey,
I’m in need of someassistance. I have a formula in place at the moment which is automatically copyingthe contents of a range of cells and inserting them all into a single cell on aseparate work sheet. I want them to copy on separate lines so the formula Ihave in place is:

='DOCUMENTS REQUIS-CONDITIONS'!A2&"
"&'DOCUMENTS REQUIS-CONDITIONS'!A3&"
"&'DOCUMENTS REQUIS-CONDITIONS'!A4&"
"&'DOCUMENTS REQUIS-CONDITIONS'!A5&"
"&'DOCUMENTS REQUIS-CONDITIONS'!A6&"
"&'DOCUMENTS REQUIS-CONDITIONS'!A7&"
"&'DOCUMENTS REQUIS-CONDITIONS'!A8&"
"&'DOCUMENTS REQUIS-CONDITIONS'!A9&"
"&'DOCUMENTSREQUIS-CONDITIONS'!A10

This is all workingfine until I need to delete one of the cells that was automatically copied. I’llexplain as best I can; I have content in every cell from A2 to A10 and theywere all automatically copied onto the other work sheet, with the content ofeach cell appearing on a new line (alt+enter). If I go back and delete cellsA3, A4, A5, A6 (example), they will be deleted in the other work sheet as well,where they were automatically copied, which is fine, however there is now alarge gap between the content of cell A2 and the content of cell A7 (same cell but large space where the deleted content was).


Is there a way for thecells that are now empty on the original sheet to not show up on the other worksheet, to avoid havingany large gaps.


I don’t care about thegaps in the original worksheet but I don’t want the gaps in the second sheetwhere the content is being copied onto. I tried removing the gaps on theoriginal sheet by deleting the cells entirely and moving everything together,but that just messes with the formula.



Any help would beappreciated

 

[CAMARD2]

It looks like my spacebar wasn't working throughout some of that post but it definitely was not like that before I posted it lol. Bug? Oh well, sorry about that

 

[CAMARD2]

Anyone ??