Hi All,

I am need of some VBA help.

I think this is pretty simple but i cant determin a way to do it.

The scenario is that i have some coding which already looks for a cell range of "B6" and autofills the column down if there is data in B6. However if there is no data in B6 it just overwrites the previous cell in the master sheet.

I need some coding which will tell the sheet:

If B6 is empty then move on to the next sheet or something along them lines.

I hope this makes sense. If i have not put enough detail into my question please message my thread back and ill give you more.

Cheers

Test