Well, give us some details. What data do you have in your original
sheet? Where are the dates, and do these increase each day? Do you
have several entries for each date? What exactly do you want to
extract? etc. etc.

Pete

On Mar 10, 12:25*pm, Code Numpty
wrote:
I knew I didn't word it well.

Information is often being added or changed in the original sheet but it is
always sorted back into date order on save.

What I need is for the extracted data to appear automatically in the other
sheet and always be up to date.



"Pete_UK" wrote:
If you apply a filter to the date column for the selected date you can
then just highlight the visible rows and copy/paste or cut/paste them
elsewhere (eg another sheet) to extract them.

Hope this helps.

Pete

On Mar 10, 9:08 am, Code Numpty
wrote:
I probably didn't title this too well.

I have a spreadsheet with 500 rows of data, sorted by the date in column A.
I want to extract certain data from rows that all start with the same
specified date.

Previously I used an IF formula but that necessitates having the formula in
500 rows which won't work for my purposes.

I'm going round incircles trying to think how best to achieve this.

.- Hide quoted text -

- Show quoted text -