Expediting Tedious Work (Will Pay!)

mikemillsjr

New Member
Joined
Dec 19, 2005
Messages
14
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!
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Sharkie21

Active Member
Joined
Nov 2, 2005
Messages
319
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

Legend
Joined
May 15, 2003
Messages
29,536
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
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,219
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

Could you not just use VLOOKUP?
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,219
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

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

New Member
Joined
Dec 19, 2005
Messages
14
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

Legend
Joined
Sep 3, 2002
Messages
10,473
What should happen to the rest of the columns?

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

Sharkie21

Active Member
Joined
Nov 2, 2005
Messages
319
Correct me if I'm wrong, but you want

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

Watch MrExcel Video

Forum statistics

Threads
1,123,010
Messages
5,599,330
Members
414,305
Latest member
scarletX

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top