Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Copy/Search/Paste Help Needed ASAP!
I have two worksheets. Worksheet A is the file I'm currently enterin data into. Worksheet B is completed and features every zip code in th US in column 1 and the closest large city corresponding to each zip cod in column 7. I have the zip codes (which I am entering into column 1 o Wksheet A), but have to search (Ctrl+F) Wksheet B with each zip code, g to the found zip code, scroll over 6 columns, copy the city name, the paste that into column 2 of Wksheet A. I am hoping there's a way t make a macro for this, but can't figure out how to make it work with different zip code every time. Can anyone figure this out??? I hav 2,000 of these to do and going back and forth is killing me literally. If it's helpful, what I've been doing is 1)entering a zip code into col.1 of Wksheet A 2)copy that zip 3)activate Wksheet B and Ctrl+F to bring up Find feature 4)paste zip code into Find feature and hit enter 5)go to designated row with correct zip, then find the correspondin city (same row as "found zip", but in column 7) 6)copy the corresponding city out of col. 7 of Wksheet B 7)Activate Wksheet A and paste the city name into col.2 of Wksheet A Row after row of this is making me nuts.. -- NWil ----------------------------------------------------------------------- NWill's Profile: http://www.excelforum.com/member.php...fo&userid=1466 View this thread: http://www.excelforum.com/showthread.php?threadid=26286 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy-Paste Alternative Needed... | Excel Discussion (Misc queries) | |||
Search, copy and paste help | Excel Discussion (Misc queries) | |||
Copy and Paste help needed - tia! | Excel Worksheet Functions | |||
Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
Copy and Paste (Tom already in disscussion - more help needed) | Excel Programming |