Hi
I had formulas to collect data when you select a certain invoice number but it's not pulling the info thro if there is more than one data for the same invoice number. Would I need a code? If so could somebody please help me out. Also is there a way to link the arrears letter to which ever unit is outstanding if not, not to worry about that for now.
I have a file with notes for what I need. See attached.
Thanks in advance.
If I understand correctly then the following should be of some help.
1) To get the Invoice # column on the 'Invoice Details' sheet, to increment paste the following into cell B8 and copy down: =CONCATENATE(C8,"-",TEXT(COUNTIFS(C$8:C8,C8),"0000"))
Note: I take it that the CONCATENATE function has been shortened to CONCAT for the 2013 version so the following should work (however I don't have that version so I can't test): =CONCAT(C8,"-",TEXT(COUNTIFS(C$8:C8,C8),"0000"))
2) Paste the following in H10 and copy down: =-(P8-O8)
3) Paste the following in O8 and copy down: =IF(L8-M8>0,L8-M8,0)
4) Paste the following in P8 and copy down: =IF(L8-M8<=0,M8-L8,0)
5) Change the second conditional formatting rule for this table to: Cell Value > 0 (applies to $P$8:$P$13, fill green)
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
@JeteMC
Thanks for reply
You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks