M
mikemillsjr
I've attached a screen cap below:
I am working on a large Excel Database file. My next step is to input
2005's Information into the main excel file and arrange the data by zip
code. As you can see from the screen cap, the information that I
imported into the file is not automatically spaced out to match up
Column AV to Column C's Zip Code Arrangements. For Example C6 & AV6
Zip Codes do not match, instead it should be C10 & AV6. Instead of
manually moving each Zip Code down to match up zip codes, is there any
query or program I can run to space out the zip codes and make them
match up zip code for zip code? The data in columns AW & AX also need
to shift with the zip codes.
If someone can help me with this program, I am will to paypal a couple
dollars for their help, thanks a lot!
+-------------------------------------------------------------------+
|Filename: screencap.JPG |
|Download: http://www.excelforum.com/attachment.php?postid=4129 |
+-------------------------------------------------------------------+
I am working on a large Excel Database file. My next step is to input
2005's Information into the main excel file and arrange the data by zip
code. As you can see from the screen cap, the information that I
imported into the file is not automatically spaced out to match up
Column AV to Column C's Zip Code Arrangements. For Example C6 & AV6
Zip Codes do not match, instead it should be C10 & AV6. Instead of
manually moving each Zip Code down to match up zip codes, is there any
query or program I can run to space out the zip codes and make them
match up zip code for zip code? The data in columns AW & AX also need
to shift with the zip codes.
If someone can help me with this program, I am will to paypal a couple
dollars for their help, thanks a lot!
+-------------------------------------------------------------------+
|Filename: screencap.JPG |
|Download: http://www.excelforum.com/attachment.php?postid=4129 |
+-------------------------------------------------------------------+