Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Jason Morin Please Respond
Hi Jason,
I saw that you were very helpful to several other people in the excel discussion on Microsoft Office Online, and am hoping that you can help me with a problem I am having. I am working on a spreadsheet for a manager of mine, where they have a list of people that were hired with their corresponding hire dates listed after their names. After their hire date, there is a separate column for their review dates. While their hire dates are in date order, their review dates are not. I would like to link all of the January review dates to a separate January sheet, February to a February sheet, so on and so forth. The problem I am having is that when I bring them over using the =if formula, they are being brought over in the row number that they are in on the master sheet, which leaves several spaces between entries bases on the number of people there are between similar months. I am sure that I am making this much more confusing and difficult than it needs to be, so any suggestions or help would be greatly appreciated. Thanks! Nicole |
#2
|
|||
|
|||
Nicole-
I do like to help, but there are a lot of other capable Excel users in this forum who would be glad to assist you. As for your question, I think you're making it too difficult by attempting to segregate the data onto several worksheets. I would suggest adding a formula to one column, and using AutoFilter to filter by month. Let's assume the review dates are in column C. In col. D, put "Review Month"" in D1 and in D2 put: =TEXT(C2,"mmmm") and copy the formula down to the end. Now select all the columns with data (assuming col. A - D here), and go to Data Filter AutoFilter. Now click on the arrow for col. D and select a month. HTH Jason Atlanta, Ga -----Original Message----- Hi Jason, I saw that you were very helpful to several other people in the excel discussion on Microsoft Office Online, and am hoping that you can help me with a problem I am having. I am working on a spreadsheet for a manager of mine, where they have a list of people that were hired with their corresponding hire dates listed after their names. After their hire date, there is a separate column for their review dates. While their hire dates are in date order, their review dates are not. I would like to link all of the January review dates to a separate January sheet, February to a February sheet, so on and so forth. The problem I am having is that when I bring them over using the =if formula, they are being brought over in the row number that they are in on the master sheet, which leaves several spaces between entries bases on the number of people there are between similar months. I am sure that I am making this much more confusing and difficult than it needs to be, so any suggestions or help would be greatly appreciated. Thanks! Nicole . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Jason Morin B$1 to B1 NOT working...HELP!!! | Excel Worksheet Functions |