LutonBarry
05-23-2013, 01:36 PM
I think this is very difficult, well it looks impossible so far with my attempts to get it right.
What I have and will attach a sample spreadsheet, is a daily call report. The report is updated daily and at this stage of my filtering has duplicated call ID's see column B. The call are sorted by call ID and then Days Old. So two lines per call with the older call above it's partner call.
What I want to do is to be able to update the data in the row cells for the higher days old call for the columns highlighted in green from the row above, if no other entry exists already exisits in that active cell. So for example Row 3 would need to have cells C3,E3,F3,J3,K3,L3 and M3. While Row 5 C5,F5,I5,J5,K5,L5 and M5.
I have posted a question my first last weekend and was very impressed with the speed of response and also the sheer quality. I hope one day I can pay this help back by answering some of the queries.
What I have and will attach a sample spreadsheet, is a daily call report. The report is updated daily and at this stage of my filtering has duplicated call ID's see column B. The call are sorted by call ID and then Days Old. So two lines per call with the older call above it's partner call.
What I want to do is to be able to update the data in the row cells for the higher days old call for the columns highlighted in green from the row above, if no other entry exists already exisits in that active cell. So for example Row 3 would need to have cells C3,E3,F3,J3,K3,L3 and M3. While Row 5 C5,F5,I5,J5,K5,L5 and M5.
I have posted a question my first last weekend and was very impressed with the speed of response and also the sheer quality. I hope one day I can pay this help back by answering some of the queries.