D
DukeDevil
Column A has a list of Items and Column B has the date that each item
was put into the spreadsheet. I need to populate a list of all the
items that have been added over the past week. For example, Columm A
has items Peach, Pear, & Plum. Column B has respective dates 5/1, 7/2,
7/5. On another worksheet, when I type in 7/6, I want Pear and Plum to
appear since they were added within the last 7 days of 7/6.
Is there any way to run such a query? maybe using VBA? Please help.
Thank you.
was put into the spreadsheet. I need to populate a list of all the
items that have been added over the past week. For example, Columm A
has items Peach, Pear, & Plum. Column B has respective dates 5/1, 7/2,
7/5. On another worksheet, when I type in 7/6, I want Pear and Plum to
appear since they were added within the last 7 days of 7/6.
Is there any way to run such a query? maybe using VBA? Please help.
Thank you.