You will need to post a copy of the sheet in order to get any reasonable chance of assistance. It would also be very useful if you could indicate what you are expecting the automation to deliver - this is best done with a manually compiled example.