I have information that is on one worksheet that needs to be on another also. The information is date based. Is there a way to automatically have the information added to the 2nd worksheet?
Example:
Name Rec. Date Due Date
Joe 7/23/07 8/18/07
This information is on 'Tab' July 2007, I need to copy it to another worksheet named: August 2007(same workbook) and insert it in the worksheet in date order(from 1st to 31st). I also would like this to be versitile enought to copy this information to various tabs(Sept, Oct. ect) based on the due date. I am running a macro on the sheet also which formats cells
Example:
Name Rec. Date Due Date
Joe 7/23/07 8/18/07
This information is on 'Tab' July 2007, I need to copy it to another worksheet named: August 2007(same workbook) and insert it in the worksheet in date order(from 1st to 31st). I also would like this to be versitile enought to copy this information to various tabs(Sept, Oct. ect) based on the due date. I am running a macro on the sheet also which formats cells
