I am running reports of a DB. Problem is that I have information that is
left blank, if the information in question has multiple entries. For
example:


Store Name Store Group Product


X ABC
H
Blank (X) Blank (ABC)
J
Y ABC
H
Z ABC
H
Blank (Z) Blank (ABC)
J
Blank (Z) Blank (ABC)
I



So the blank cell should have contained the same info as the cell
directly above it. Any help on VBA to achieve this?


--
Thiem
------------------------------------------------------------------------
Thiem's Profile: http://www.excelforum.com/member.php...o&userid=27474
View this thread: http://www.excelforum.com/showthread...hreadid=499318