DarrelKelly
New Member
- Joined
- Apr 21, 2017
- Messages
- 1
I have a list of zip codes in a verticle column (A32:A200) on a sheet Named "Formulas". I have an image named "Bolt" in cell C4 on a sheet, named "New Job Log".
Also on that New Job Log sheet, I have two non adjacent columns.
On the left, starting at C5 is an empty column of cells.
On the right, starting at E5 and ending at row xxx (a number yet to be determined but assume max number of rows allowed) are cells containing the client's address in the form of
Mr. Jones
1234 Street
His City, State, zip code
I want to insert the image (Bolt) in column C in the same row of an address cell containing any of the zip codes on the list found on the formula sheet.
For example, where the list on the Formulas sheet includes 93458
A B C D E
12-Dec Job#3 View attachment 80655 Residential Mr. Jones
1234 Street
His City, State, 93458
Also on that New Job Log sheet, I have two non adjacent columns.
On the left, starting at C5 is an empty column of cells.
On the right, starting at E5 and ending at row xxx (a number yet to be determined but assume max number of rows allowed) are cells containing the client's address in the form of
Mr. Jones
1234 Street
His City, State, zip code
I want to insert the image (Bolt) in column C in the same row of an address cell containing any of the zip codes on the list found on the formula sheet.
For example, where the list on the Formulas sheet includes 93458
A B C D E
12-Dec Job#3 View attachment 80655 Residential Mr. Jones
1234 Street
His City, State, 93458
