Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a master spreadsheet that has a list of people with dates
corresponding to each person. I want to link all of the January dates to a January sheet, Februaty dates to a February sheet, so and so forth. The dates are not in order, and I am using an =IF formula to bring them over to each corresponding sheet. The problem is that when they are in the corresponding sheet, they are being brought over in the row number that they are in on the master sheet, which leaves several spaces between entries based on the number of people there are bewteen similar months. I'm sure I am making this more confusing than it should be, but I need help with how I can do this easier. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do i set up a formulas with an if date? | Excel Worksheet Functions | |||
Min/Max formulas using cells with date format | Excel Worksheet Functions | |||
Date Formulas | Excel Discussion (Misc queries) | |||
Excel 2002 date formulas problem | Excel Worksheet Functions | |||
Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions |