Hi all,

I'm curious if it's possible to copy data from one TAB into another based on
certain criteria.

For example: if you have a spreadsheet with customers account numbers,
geographical location and a date to contact them. Would it be possible for a
formula to, based on todays date, go check what dates to contact a customer
is coming up this week, split the result up by geographical location, and
onto different TABs? The result should only include customers who needed to
be contacted within the workweek.

Any ideas or suggestions?

Thanks,
Tom