Automatic fill cells according some rules

**chrism_cfu** · 05-15-2013, 05:54 AM

Hi to all!! I need your help once again!
I would like to fill some cells with a customer id if this customer is the same as the cell bellow.
As my example below. (sorry I can upload the file through company’s policy)

CUSTOMER id CUSTOMER NAME TYPE
737346 Nikos 81
1154765 Kyriakos 81

1154780 Thanos 81

I would like to fill automatically the empty cell bellow Kyriakos the customer id 1154765 in new column.
I want in column "new" to fill with customer id and when the customer id is empty to fill the same customer id as above customer id.
like the exaple below

CUSTOMER id CUSTOMER NAME TYPE new
737346 Nikos 81 737346
1154765 Kyriakos 81 1154765
1154765
1154780 Thanos 81 1154780

thanks a lot!!!

**chrism_cfu** · 05-16-2013, 10:04 AM

i found the solutions

thanks anyway!

**arlu1201** · 05-18-2013, 03:04 AM

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.

**chrism_cfu** · 05-20-2013, 02:09 AM

i used this macro:

Please Login or Register  to view this content.

http://dmcritchie.mvps.org/excel/fillempt.htm

**arlu1201** · 05-20-2013, 02:14 AM

chrism,

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. In order to put code tags, either type [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] at the end of it, OR you can highlight your code and click the # icon at the top of your post window.