Expediting Tedious Work (Will Pay!)

[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!

 

[Sharkie21]

Sounds like what you're doing requires a simple macros. I don't see your screen cap so it's hard to follow along. I'm sure someone will do it for free, if not try to get a screen cap and I'll take a look into it.

 

[Smitty]

Welcome to the Board!

If you take a look to the bottom of the page, you'll find a link to Colo's HTML Maker, which will let you post a shot of your sheet.

For a paid solution, you might want to contact the Board's host, Mr. Excel (aka Bill Jelen), @ consult@MrExcel.com.

Hope that helps,

Smitty

 

[mikemillsjr]

Sorry, screencap here ---> http://www.newtechcity.net/screencaps/screencap1.jpg

Thanks for the info MVP!

 

[Norie]

Could you not just use VLOOKUP?

 

[mikemillsjr]

I'm a novice to Excel, I have minimum experience, so help would be appreciated.

 

[Norie]

Well to return the two columns of data for the corresponding zip code in column C you could use something like this.

=VLOOKUP(C6, $AV$6$AX$1000, 2 , 0) - for avg Actual Appts

=VLOOKUP(C6, $AV$6$AX$1000, 3 , 0) - for #Events

Change the 1000 to cover however many rows of data there is.

 

[mikemillsjr]

http://www.newtechcity.net/files/Extracted Data.xls

I extracted the data out of the main excel file and put them in columns a-d so I didn't have to upload the entire file which is well over 100mbs. You can better understand exactly what I want to do. Columns A & B need to match up zip code for zip code, for example A5 & B5 match, but A10 should match B6. Manually I would have to drag and drop cells for the entire file which will take a very long time. Therefore, I’m wondering if there is a way to make the data from Column B match A. The data for Columns C & D would also have to shift as well. Let me know, thanks!

 

[just_jon]

What should happen to the rest of the columns?

EDIT -- and are there matches for every zip code, and only 1 match?

 

[Sharkie21]

Correct me if I'm wrong, but you want

01001 1001 65 2
01002
01003
01004
01005
01007 1028 73 1
...