View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Luke Luke is offline
external usenet poster
 
Posts: 142
Default Rephrased - Remove blank cells - no sorting, copy or pasting

Max,
How would I include other sheets in these formula?
I have another sheet that would essentially take the place of RowA.
I Should have said that in the first place but I thought I could figure it
out.
Thanks Max
Luke
Example: Sheet1
A
1 8
2 6
3
4 2
5 5
6 6
7
8
9 4
Sheet2:
B
1 8
2 6
3 2
4 5
5 6
6 4
7
8
9

"Max" wrote:

Welcome, glad it worked out ok for you.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Luke" wrote in message
...
Very much Appreciated!!!! I can't tell you how happy I am right now :)
Thank you again Max, you are most excellent!
Luke