Copy and Paste IF Macro

[sweedey]

I am looking to write a macro that will do 3 things

1. Copy and paste recently added - that is not yet complete - data from a table (anything added within the past 3 days)
2. Copy and paste recently completed data (anything completed within the past 3 days)
3. Copy and paste the most recent "Key to Key" input

Looking at the Input Tab:

#1 would copy based on the input in column B -as long as M, or I, has not been completed yet.
#2 would copy based on the input in column M or I - whichever is easiest
#3 would copy based on the input in column D being "Key to Key" and the input in column B being closest to today's date

Both of these would then be copied into their respective areas in the "Key to Key" tab.

The problem is - I know this should be fairly simple but I can not seem to get it to work like I want it to for anything. Can anyone help?


Help Version.xls

[xladept]

Hi Sweedey,

I may have something for you tomorrow - I think I know what you want - but, from me, it will be a VBA solution

[sweedey]

anything that will get the job done is more than welcome! I appreciate any help I can get on this! Thanks!

[xladept]

Hi Sweedey,

Try this:

Please Login or Register  to view this content.