S
Stewit
Hi all hope someone can help me with this.
Column B I enter the supplier name
Column C I enter the date
Column D I enter the Invoice amount
Column E I enter the supplier name only cause I can't link it without loss
on sorting
Column F I have this formula to consolidate thte suppliers amounts
=IF(E8=0,"",SUMIF($B$8:$B$61,E8,$D$8:$D$61))
that picks up on the supplier everytime I add another invoice for a same
supplier
I'm needing a method of where i enter the data in Col B, the same name then
transfers to Column E, if the supplier name already exists in Col E it
doesn't transfer.
I also need to sort Col's B,C and D and so the link in E needs to be
independant of the search this is proving to be quite a complex solve for me
as im NOT well versed in the use of VB and i find the use of pivot tables
for my application to be quite useless.... or its just me thats useless
lol...
The problem I have is when I sort B, C and D the links in E are lost...apart
from when I manually add the Sippliers name in Col E
Anyway im hoping that with all you experts out there someone can give me the
solution or at least a point in the right direction
thanks in advance
Stewart
im happy to mail the sheet if need be, it on ly has three scripts attached
which are for sorting the BCD Cols, I will be adding another to sort the E
Col after this inital hurdle is overcome...
Column B I enter the supplier name
Column C I enter the date
Column D I enter the Invoice amount
Column E I enter the supplier name only cause I can't link it without loss
on sorting
Column F I have this formula to consolidate thte suppliers amounts
=IF(E8=0,"",SUMIF($B$8:$B$61,E8,$D$8:$D$61))
that picks up on the supplier everytime I add another invoice for a same
supplier
I'm needing a method of where i enter the data in Col B, the same name then
transfers to Column E, if the supplier name already exists in Col E it
doesn't transfer.
I also need to sort Col's B,C and D and so the link in E needs to be
independant of the search this is proving to be quite a complex solve for me
as im NOT well versed in the use of VB and i find the use of pivot tables
for my application to be quite useless.... or its just me thats useless
lol...
The problem I have is when I sort B, C and D the links in E are lost...apart
from when I manually add the Sippliers name in Col E
Anyway im hoping that with all you experts out there someone can give me the
solution or at least a point in the right direction
thanks in advance
Stewart
im happy to mail the sheet if need be, it on ly has three scripts attached
which are for sorting the BCD Cols, I will be adding another to sort the E
Col after this inital hurdle is overcome...