I am looking for a formula which extracts a list from data in sheet1to sheet2 filtered by a starting

V

vivace

Salut Master of Excel

I am looking for a formula which extracts a list from data in sheet1 to sheet2.

In sheet1 I have data in range B1:F1000 with in column A dates.
In sheet2 I have in A1 a date '01.01.2012' and in B1 date '01.06.2012'.

Now in sheet2 I want to have a list in range B1:F1000 with extracted data from sheet1.B1:F1000 which is from date sheet1.A1 to sheet1.B1.

I hope my info is clear enough.

Is this possible? Thank you for your time and information.
 
I

info

Salut Master of Excel

I am looking for a formula which extracts a list from data in sheet1 to sheet2.

In sheet1 I have data in range A2:F2000 with in column A dates.
In sheet2 I have in A1 a date '01.01.2012' and in B1 date '01.06.2012'.

Now in sheet2 I want to have a list in range A3:F1000 with extracted data from sheet1.B1:F1000 which is from date sheet1.A1 to sheet1.B1.

I hope my info is clear enough.

Is this possible? Thank you for your time and information.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
Sumproduct function allow a lookup for one Date to check if it fallsin Date Range in other table 9
Excel formula referencing cells 4
Display weeks from a Milestone 0
How to Copy data from a row to a column 3
Automatically copying data from sheet1 to sheet2 2
Copy data automatically from sheet1 to sheet2 0
MACRO RUN random percentage and copy of column values 1

Top