excel vba problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tans - 07 Apr 2004 04:56 GMT

Hi, I have columns that I tried to change the cell information t
another cell that have to be the blank for a row that contains directo
name in cell A and for the movie titles I have to have director name
instead of the titles.I totally lost, please help me, the data in cel
B sholuld have to be,

A
1 D:B.Jane
2 T:Back to the future
3 T:Aliens
4 T:X-files
5 D:Adam Mathew
6 T:Core
7 T:Titanic
B
1 (empty)
2 D:B.Jane
3 D:B.Jane
4 D:B.Jane
5 (empty)
6 D:Adam Mathew
7 D:Adam Mathew

Thanks in advance for any suggestions

--
Message posted from http://www.ExcelForum.com

Reply to this Message

jim - 07 Apr 2004 05:44 GMT

please try the formula listed below.

> Hi, I have columns that I tried to change the cell information to
> another cell that have to be the blank for a row that contains director
[quoted text clipped - 23 lines]
> ---
> Message posted from http://www.ExcelForum.com/

Reply to this Message