- Joined
- Jun 6, 2010
- Messages
- 1
- Reaction score
- 0
Hello,
I am trying to set up a worksheet that pulls values from a list in another worksheet. The original sheet looks likes this:
10-00242 case_md epi
10-00244 case_md epi
10-00249 case_md epi
And I want the new sheet to look like this (no blank cells between the values):
10-00242 case_md epi
10-00244 case_md epi
10-00249 case_md epi
I've tried the small formula for my first column, but that only seems to work for standard numbers (not the type I have). Any ideas on how I could set this up? Thanks in advance for any advice, I really appreciate it.
Meg
I am trying to set up a worksheet that pulls values from a list in another worksheet. The original sheet looks likes this:
10-00242 case_md epi
10-00244 case_md epi
10-00249 case_md epi
And I want the new sheet to look like this (no blank cells between the values):
10-00242 case_md epi
10-00244 case_md epi
10-00249 case_md epi
I've tried the small formula for my first column, but that only seems to work for standard numbers (not the type I have). Any ideas on how I could set this up? Thanks in advance for any advice, I really appreciate it.
Meg