Copy Data from One Tab to Another Tab based on Dates

  • Hello,

    I have a spreadsheet (see attached), where I would like to copy specific data from tab labeled 2020 to tab labeled Outstanding Log. The following data is to be copied: Column Q from 2020 to Column A on Outstanding Log, Column A from 2020 to Column B on Outstanding Log, Column E from 2020 to Column C on Outstanding Log; Column N from 2020 to Column D on Outstanding Log, Column J from 2020 to Column E on Outstanding Log, and Column V from 2020 to Column F on Outstanding Log. However, I only want to copy data over within the last 30 days using the dates from Columns E and J on the 2020 tab, and where there is no date in Column AC.

    I'm not sure if this could be done with a formula or not, so I thought I'd post it here first.

    Thank you!