Pull Data from the list table based given date.

**Gosa120303** · 03-14-2016, 04:09 PM

Hi,

I have a table in excel contains users and tasks planned date wise to them.

If I enter date of a particular date tasks assigned to that date should get listed. Column A contains users Column B, C, D and E contains date as header and numbers below each date. In the next sheet if I enter a date from the list number listed for that particular date should get listed here.

Date 13-Mar 14-Mar 15-Mar r
User 1 10 20 15 45
User 2 25 15 20 15
User 3 10 35 10 20
User 4 15 45 20 10

13-Mar
User 1
User 2 Here it should pull data from the list above bases on date highlighted in Green
User 3
User 4

Thanks.

**alansidman** · 03-14-2016, 04:41 PM

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window (or use the paperclip icon).

**alansidman** · 03-14-2016, 04:42 PM

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window (or use the paperclip icon).

Pull Data from the list table based given date.

LinkBack

Thread Tools

Rate This Thread

Display

Pull Data from the list table based given date.

Re: Pull Data from the list table based given date.

Re: Pull Data from the list table based given date.

Thread Information

Users Browsing this Thread

Similar Threads

Need to pull pivot table column on new sheet based on a data field (like date) - how?

[SOLVED] Pull data from pivot table based on date

Pull Data from Multiple Columns Based On Data Validation List Selection

Pull row of Data based on date

Pull data from worksheet based upon date

Pull data from list based on certain criteria

Pull data based on date

Bookmarks

Bookmarks

Posting Permissions