I am pulling data from various worksheets into one central sheet in order to reconcile.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
<o></o>
In column B I have a list of unique identification numbers <o></o>
In column J I have a list of unique identification numbers <o></o>
These are compared in column G using =IF(B7<>J7,"WRONG","OK ")<o></o>
<o></o>
Columns C & D contain sumif functions in order to look up the result in B pull data from other sheets<o></o>
E = sum of C+D<o></o>
<o></o>
Columns K,L,M & N contain sumif functions in order to look up the result in J pull data from other sheets<o></o>
O = sum of K+L+M+N<o></o>
<o></o>
E & O are compared in column H simply by using E-O<o></o>
<o></o>
Now all of the above works fine but I have a couple of issues which hopefully can be solved using some code<o></o>
<o></o>
1) If C & D both = 0 I would like to delete cells B,C,D & E on that particular row<o></o>
2) If K,L,M & N = 0 I would like to delete cells J,K,L,M,N & O on that particular row<o></o>
(Please note that I don’t just want to see if E or O = zero because if they do but this is because +/- numbers on the other cells they need to stay)<o></o>
<o></o>
Once the above has been executed I need to make sure that B & J are the same<o></o>
If B & J are different I will need to insert some cells<o></o>
For example if B&J are different but J=B on the row below I would want to insert cells from J,K,L,M,N & O and vice verse<o></o>
I would need to run this from row 7 to 1000<o></o>
<o></o>
(would the above be possible or can you think of a better solution ?
<o></o>
Many Thanks<o></o>
James<o></o>
<o></o>
<o></o>
<o></o>
<o></o>
fficeffice" /><o></o><o
></o>In column B I have a list of unique identification numbers <o
></o>In column J I have a list of unique identification numbers <o
></o>These are compared in column G using =IF(B7<>J7,"WRONG","OK ")<o
></o><o
></o>Columns C & D contain sumif functions in order to look up the result in B pull data from other sheets<o
></o>E = sum of C+D<o
></o><o
></o>Columns K,L,M & N contain sumif functions in order to look up the result in J pull data from other sheets<o
></o>O = sum of K+L+M+N<o
></o><o
></o>E & O are compared in column H simply by using E-O<o
></o><o
></o>Now all of the above works fine but I have a couple of issues which hopefully can be solved using some code<o
></o><o
></o>1) If C & D both = 0 I would like to delete cells B,C,D & E on that particular row<o
></o>2) If K,L,M & N = 0 I would like to delete cells J,K,L,M,N & O on that particular row<o
></o>(Please note that I don’t just want to see if E or O = zero because if they do but this is because +/- numbers on the other cells they need to stay)<o
></o><o
></o>Once the above has been executed I need to make sure that B & J are the same<o
></o>If B & J are different I will need to insert some cells<o
></o>For example if B&J are different but J=B on the row below I would want to insert cells from J,K,L,M,N & O and vice verse<o
></o>I would need to run this from row 7 to 1000<o
></o><o
></o>(would the above be possible or can you think of a better solution ?
<o
></o>Many Thanks<o
></o>James<o
></o><o
></o><o
></o><o
></o><o
></o>
