How do I pull info from one Sheet in Excel to another, given that it meets an entered date range?
-
I am trying to pull information from one sheet in Excel to another, given an entered date range. In Sheet1, there a work task descriptions under the heading TASKS, there is a date under the heading START DATE, and there is a date under the heading END DATE. I want to go into Sheet2 and enter in a start date, and an end date, and have the work descriptions display underneath, if and only if the START DATE and END DATE in Sheet1 fall under the entered date range specified in Sheet2. Can anyone help me out?
-
Answer:
You would have to use VBA, either a macro or event handler, to accomplish this. What are your sheet names for each 'from' and 'to' sheet, and which columns contain your starting and ending dates?
Kelly at Yahoo! Answers Visit the source
Related Q & A:
- How can I plot more than one value in the same date?Best solution by Mathematica
- How do I import contacts from one e-mail address to another?Best solution by support.google.com
- How can I move bookmarks from one email to another one?Best solution by pcworld.com
- How do you transfer info from one account to another in Yahoo?Best solution by Yahoo! Answers
- How can I transfer contacts from one phone to another?Best solution by eHow old
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.