https://skydrive.live.com/redir?resid=2B056BF5C3A60DD1!207
I have a list of 3-letter codes in column A which are associated with dates in column B. This list contains dates for the entire year of 2014, and must be sorted by column A, alphabetically. On sheet 2 (titled Returns per Month), I have 2 columns for every month. I would like the columns A&B from sheet 1 to be automatically sorted into the proper month's columns on sheet 2. On sheet 2, I want the data to be sorted by date, then code. I will be constantly inserting lines with more data throughout the year. The whole purpose of having sheet 1 automatically sort itself into sheet 2 was to prevent me from having to select all of sheet 1 and sort it by column B, then move over the specific month into sheet 2, then re-sort sheet 1. Since new data is constantly being added into sheet 1, this would help keep sheet 2 accurate at all times, without maintenance.
I was trying to find a formula that would copy over the range (A4:B1000) from sheet 1 into sheet 2’s A/B (Jan), C/D (Feb), E/F (Mar) etc.. but also neglect any blank cells or cells that contain dates from any month other than the specified month.
I’m sure something like this is possible, but I’m assuming it would involve macros, which I have no experience with. Help please!
I’ve uploaded the workbook above, so anyone who wants to help me can see what I am trying to achieve. I’ve manually entered the information into where it belongs on sheet 1 and 2. Data is never entered into sheet 2, but I have added it so it looks the way I want it to end up.
I have a list of 3-letter codes in column A which are associated with dates in column B. This list contains dates for the entire year of 2014, and must be sorted by column A, alphabetically. On sheet 2 (titled Returns per Month), I have 2 columns for every month. I would like the columns A&B from sheet 1 to be automatically sorted into the proper month's columns on sheet 2. On sheet 2, I want the data to be sorted by date, then code. I will be constantly inserting lines with more data throughout the year. The whole purpose of having sheet 1 automatically sort itself into sheet 2 was to prevent me from having to select all of sheet 1 and sort it by column B, then move over the specific month into sheet 2, then re-sort sheet 1. Since new data is constantly being added into sheet 1, this would help keep sheet 2 accurate at all times, without maintenance.
I was trying to find a formula that would copy over the range (A4:B1000) from sheet 1 into sheet 2’s A/B (Jan), C/D (Feb), E/F (Mar) etc.. but also neglect any blank cells or cells that contain dates from any month other than the specified month.
I’m sure something like this is possible, but I’m assuming it would involve macros, which I have no experience with. Help please!
I’ve uploaded the workbook above, so anyone who wants to help me can see what I am trying to achieve. I’ve manually entered the information into where it belongs on sheet 1 and 2. Data is never entered into sheet 2, but I have added it so it looks the way I want it to end up.
