View Single Post
  #1   Report Post  
Buildscharacter
 
Posts: n/a
Default Auto Inserting numbers


I have two large lists of numbers with corresponding data in the cell
adjacent to them. I would like the list of numbers to match (inserting
cells where there are gaps). Is there any way to quickly and easily do
this?

For Example:

1 a 1
2 b 2
3 c 4
4 d 5
5 e 6
6 f 7

I would like it to automaticalls insert a space where the "3" should be
in the 3rd collumn. Thanks.


--
Buildscharacter
------------------------------------------------------------------------
Buildscharacter's Profile: http://www.excelforum.com/member.php...o&userid=28783
View this thread: http://www.excelforum.com/showthread...hreadid=484720