Extracting Date Specific Data formula

**Sandpit** · 03-01-2011, 09:39 AM

Hi All,

I have a rolling monthly log book from which I need to extract specific data relating to Today e.g. every day certain data needs to be sent to a different department relating only to specific data.

I need some help in formatting a formula so that when a workbook is opened data from the Log Book will extract the required information based on the date i.e. IF(TODAY) ......... all rows will be filled in from the log book with relating date.

Thanks in advance

**NBVC** · 03-01-2011, 10:03 AM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

**Sandpit** · 03-01-2011, 10:38 AM

I have attached a sample - I need to extract the specific data from Movements Log sheet to Arrivals Sheet on a daily basis and send on; therefore The Arrival sheet dates will relate to Today (based on Computer time) extracting the data from date concerend in the Log.

**NBVC** · 03-01-2011, 11:03 AM

Add a helper column in Movements sheet:

In X3 insert formula: =IF(A3=TODAY(),COUNT(X$2:X2)+1,"") and copy down

in Y3 insert formula: =MAX(X:X)

in the Arrival sheet, first select everything and format as General (it seems you have everything formatted as TEXT)

Then insert formula in C3: =IF(ROWS($A$3:$A3)>'MOVEMENTS LOG'!$Y$3,"",INDEX('MOVEMENTS LOG'!F:F,MATCH(ROWS($A$3:$A3),'MOVEMENTS LOG'!$X:$X))) and copy down

use similar formulas in other columns adjusting the Index range to get appropriate info.