Autoshift cells when overlapping

[Vasanth88ece]

Hey All,

I m looking for a VBA code when there is a overlapping occur in a cell. For instance . I have 2 sheets Master and Slave. I m trying to copy data from master to slave with filters. In the slave sheet i have a calculation in slave A5. Whenever the filtering data from master exceed the A4 in slave My calculation in slave A5 should shift down accordingly.