How to make a table content in one column

[Etphonehome]

Hi all,

I have a table with over 100 columns & rows in which some contain text in it and some without, it depends on whether the formula hit the condition, that is saying every cell has a formula (not blank). I need them all be arranged in one column in another worksheet. What I have done is to name the table and use index to locate each cell, it works but really hard to trace back the original source if there are something wrong. Is there any simpler way to do ? And if it possible to ignore those without content ? I am sure Vba can help but I am not familiar with it, can it be done by only using formula ? If not, I will try to learn.

Thanks in advance for the help.

Et

 

[CWatts]

Do you need the new worksheet to reference back to the table, or do you just need to do something like this:

http://www.mrexcel.com/forum/showthread.php?t=541760

 

[Etphonehome]

Yes, that's exactly what I want. It seems I need to use Marco to solve my problem.

 

[CWatts]

It is probably the easiest. It hasn't been tested on a table before so let me know how it works. You might have to convert it to a range if it doesn't work.

PS make backups!

 

[Etphonehome]

Thank you, will try and let you know how it works.