Hello and thank to anyone that could help with this one.
What I would like to do is to make macro that will copy entire rows based on criteria from 3 different sheets into 1. At first I would like to copy First row from sheet Audi Q7 with header and then if in any of the last 4 columns (sheet Audi Q7) is date lesser than Today + 90 days copy the entire row. Then from Sheet VW T6 copy first row header to row under the last row copied from Audi Q7 and then again if any date in last 3 columns is lesser than Today + 90 days copy the entire row. And same for Sheet VW Touareg 3. Screens of sheet below:
https://i.imgur.com/3W1il2p.jpg
https://i.imgur.com/WzruMCO.jpg
https://i.imgur.com/w0i0406.jpg
Hope my explanation makes sense.
What I would like to do is to make macro that will copy entire rows based on criteria from 3 different sheets into 1. At first I would like to copy First row from sheet Audi Q7 with header and then if in any of the last 4 columns (sheet Audi Q7) is date lesser than Today + 90 days copy the entire row. Then from Sheet VW T6 copy first row header to row under the last row copied from Audi Q7 and then again if any date in last 3 columns is lesser than Today + 90 days copy the entire row. And same for Sheet VW Touareg 3. Screens of sheet below:
https://i.imgur.com/3W1il2p.jpg
https://i.imgur.com/WzruMCO.jpg
https://i.imgur.com/w0i0406.jpg
Hope my explanation makes sense.
