Hello,
I am looking for some help. I have a current excel worksheet that has: a1=tech name, b1=address, c1=zip. We have to manually look up the zip and then data enter into sheet, the tech number and address are copy and paste. Now here is the issue, I reassign all of my jobs so the tech numbers change in the billing system. How can I copy the tech number and address out of the billing system and have excel recognize the address column (b1) and auto fill the zip code. I have approximately 300 hundred entries. I am looking for a way to have my origianl (master) 1-300 and after reassigning 301-600 have excel recognize the address and auto fill the zip based on matching a record in the 1-300. All addresses will be an exact match?
Thanks in advance
Matt
Configuration: Excel
Use vlookup - VLOOKUP(lookup_value,table_array,col_index_num,FALSE)
|
Auto fill for named range in excel Auto fill reference to excel sheet Conditional auto fill in excel Excel auto copy of rows to different sheet based on criteria with total Excel 2003 visual basic password Excel 2007 choose dropdown list based on cell value Excel 2007 you cannot use references to other worksheets or workbooks for data validation criteria Excel fill macro Excel list all matches of a criteria Excel macro how to select columns based on header Excel systemfehler visual basic Fill column based on containing text in a different column in excel How to assign a value to a cell based on the value on the other cell in excel 2007 In vba, do auto fill till the last number available Insert row excel using visual basic Macro to insert and fill rows in excel Ms excel copy rows based on a criteria to different worksheet Next row excel macro visual basic code