View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
MarkN MarkN is offline
external usenet poster
 
Posts: 104
Default I'm trying to compile text from multiple worksheets...

Is this a single column or is the column part of a larger table/list?
--
Thanks,
MarkN


"leigoze" wrote:

I'm trying to compile text from multiple worksheets into a column in another
worksheet of the same excel project without having spaces...or repeated
numbers. I'd like it to compile like numbers by itself into a single cell in
the column...for example instead of:

1

2

3

2
1
4

3
I'd like it to be:

1
2
3
4
Anybody know how to do this? It would be greatly appreciated!!