Nova
01-13-2005, 08:18 AM
Hi!
I was wondering if you can help me. I want to create some sort of lookup which grabs ONLY the cells which have non zero numbers from the "CHANGES" tab. It would then list those numbers in the "EXPLANATIONS" (row d - t).
I also need to be able to populate corresponding cost center (collumn A) and account ( collum B) in the explaination tab with a found value.
Please the attachment.
I would assume I need to create a loop, but I'm not sure how to organize it.
I was wondering if you can help me. I want to create some sort of lookup which grabs ONLY the cells which have non zero numbers from the "CHANGES" tab. It would then list those numbers in the "EXPLANATIONS" (row d - t).
I also need to be able to populate corresponding cost center (collumn A) and account ( collum B) in the explaination tab with a found value.
Please the attachment.
I would assume I need to create a loop, but I'm not sure how to organize it.