How to dynamically fill empty space in a column?

Excel 2003 - fill four new tables(columns) by data from one column ?

• I have column(A) holding data of 1 year (4 quarters).There 's another column(B) being filled by dates alongside. I want to separate (or copy) column A into four new columns(new tables automatically), while there's not exact , what row becomes new quarter. Or from the other side , 4 fixed columns(tables) are waiting to be filled up by data from column A , but 2nd,3rd,4th doesn't know when there's its turn to start picking up data from the same column(A) after start of new quarter according to column B (date). What is the easiest solution ? Thanks!! As there are some characters left , I need number of row in specific column A (when quarters change) ,which could be used as reference for first position in 2nd , 3rd , and 4 th table.

• Answer:

  I'd imagine that the easiest way to attack this problem would be by using the advancedfilter method in the workbook_open event, or in a macro. If the area of data is defined as yeardata then: Range("yeardata"). AdvancedFilter _ Action:=xlFilterCopy, _ CopyToRange:=("Destination1"), _ CriteriaRange:=Range ("Criteria1") --you'd need to run that command for each quarter (column), changing the destination range and criteria range as necessary.