Hello,
First of all, I'm using Office 2011 for Mac, in case it makes any difference.
I've created the worksheet "Status" in my workbook to summarize pending payments from all the other worksheets, which correspond to every month in the year (Janeiro, Fevereiro, Março, ..., Dezembro).
I need a formula or macro which will search column H of every month for the terms "Entregar", "Agendado" and "Atrasado" and than populate the worksheet "Status" accordingly. I need to copy not only the cell in which we find the term but also some other cells in the same row.
Just as an example, the first occurrence of "Entregar" is in the worksheet "Maio", so B5, C5, D5 and E5 would have to be filled with info from the worksheet "Maio", cells B23:24, A23:24, D23:24 and G23:24 (this are not actually ranges but merged cells) respectively. It goes like that for "Agendado" and "Atrasado".
Anyone can help me? It seems I can't do it with a formula and I don't know anything about macros...
Thanks in advance,
Juliano Arantes
Bookmarks