Hello to all of you,
i am really apreciated help in this problem: Here is speadsheet that I upload into Oracle to print checks for clients. The checks are beind printed with only name of wendors on it due to I need to type mannually addresses, city, zip code into spreadheet and if there are 5000-6000 rows that is very time comsuming. Initiially, the spreadheet has been entered only vendors names from clientss files and they don't entered in their files whloe adresses. The vendors only few so far and they are:Miami Dade County Clerk of Court, Broward County Clerk Of Court, Palm Beach County, Lee County, Baker County and eventurlly there will be all 67 counties of Florida.The vendor names are in column i. I need to eneterd whole address sich as city , street and zip code in columns J,K,L amd M respectevely. We don't have access here, only excel. I am looking for kind of array macro that would populated columns J,K,L and M with adressed based on column I -vendor. Just a bit heads up with helping to programming one vendor .
Thank you very much in advance,
The bEST Regards,
BorisGomel
i am really apreciated help in this problem: Here is speadsheet that I upload into Oracle to print checks for clients. The checks are beind printed with only name of wendors on it due to I need to type mannually addresses, city, zip code into spreadheet and if there are 5000-6000 rows that is very time comsuming. Initiially, the spreadheet has been entered only vendors names from clientss files and they don't entered in their files whloe adresses. The vendors only few so far and they are:Miami Dade County Clerk of Court, Broward County Clerk Of Court, Palm Beach County, Lee County, Baker County and eventurlly there will be all 67 counties of Florida.The vendor names are in column i. I need to eneterd whole address sich as city , street and zip code in columns J,K,L amd M respectevely. We don't have access here, only excel. I am looking for kind of array macro that would populated columns J,K,L and M with adressed based on column I -vendor. Just a bit heads up with helping to programming one vendor .
Thank you very much in advance,
The bEST Regards,
BorisGomel
