Transposing dates starting from a specific date?

[Hallaluya]

I need help transposing dates from one sheet to another, but only the dates after a specified criteria. I attached a quick mock up of what i'm using.

Example:

Sheet 1:
Rows 2-100 have names of people.
Columns E-Z need to show the transposed dates.

Sheet 2:
G1 contains the date to reference (1 year from today e.g. - 4.26.2015). This date will update each day using =Today()-365

Sheet 3-101:
Each sheet has G8-G100 that contain random dates from the past two years. These dates need to go on Sheet 1 in Columns E-Z ideally.


Currently I am using an IF formula to check the range of cells and then transpose if true, but that's obviously returning a false once the first date in the list goes past the Sheet 2: G1 date.

[oeldere]

With VBA to get all data on 1 sheet.

After that a formula to determine if the date is valid.

After that a formula to transpose the data.

See the attached file.

[Hallaluya]

Thank you so much!

[oeldere]

You're welcome. We appreciate the feedback!

If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.

It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.