Fill column according to criteria

**marreco** · 12-18-2012, 01:45 PM

Hi.
In each individual spreadsheet WC (work center), named as 121, 122, etc., must have Excel do the following:

By accessing the spreadsheet ...

1 - Sorts the spreadsheet by the column "I" (DT INÍCIO)

By clicking the "Refresh Dates"

1 - If the line contains information (columns A: H met), and the "I" is already filled, I want the column "J" (DT CONCLUSÃO) is filled with the calculation result = I + H, rounding up.

2 - If the line contains information (columns A: H met), and the "I" is empty, so I want the column "I" is filled with the largest data that is in column "J"

I believe that through a code that has a logic similar to that formula in "K2"

**marreco** · 12-19-2012, 07:57 AM

Hi
Any idea?

Thnak you!!

**marreco** · 12-19-2012, 10:09 AM

Hi
Any idea?

Thnak you!!

**marreco** · 12-19-2012, 01:10 PM

Hi
someone understood my explanation?

if necessary I try again

**HaHoBe** · 12-20-2012, 01:13 AM

Hi, marreco,

Code goes behind EstaPasta_de_trabalho (ThisWorkbook) and will exclude three sheets from being considered and act on all other sheets (this is based on the example posted and may be altered if needed):

Please Login or Register  to view this content.

This code includes the pressing of the extra button, if you want an extra button it´s the For Next-Loop which should make that up if the upperbound of rows is checked for that.

Ciao,
Holger