Hi James,

Lets ensure I understand exactly what you want to do.

Test all cells in Column B (within the used range).
If a cell is empty then delete the row.
If the cell is not empty (this is what I don't understand.) Do you want to
copy the value in column D to column B or copy the value from B to column D.
(or something else altogether.)
Repeat the process from Tab 1 to Tab 15. (This is clear.)

--
Regards,

OssieMac


"James8309" wrote:

Hi All,

I've been trying to figure out how to do this and am keep hitting to a
brick wall.

If anyone can help, that would be appreciated.


I have this excel workbook which has 15 tabs. What I am trying to do
is relatively simple

* Look at column B and if a cell in column B is empty then remove
entire row if a cell in column B is not empty then return the value in
column D in same row.

* Repeat the process from Tab 1 to Tab 15.


Thank you for your help in advance.


Happy New Year.


Regards,


James
.