Hi,

I have a user form that populates rows in a spreadsheet. On the form I have 12 Comboboxes and 12 Textboxes. Upon entering the data with a button control the data populates 24 non-contiguous cells in a row. I need to produce a weekly and monthly report which lists and counts the contents of these 24 cells. I have used COUNTIF formulas to count all 24 cells and and can list the combobox entered cells but I need to list the contents of the textboxes as well on another sheet IF they correspond to a certain week number or month.

As an example Week 26 may have 30 rows of data and I need to make a report on another sheet which lists the text content of the 12 textbox-entered cells in each row. The text in the cells could be anything and there may also be duplicates. I've used the combo-boxes as far as possible as a form of data validation but have had to use textboxes on the user form for issues not covered by the comboboxes. There is a good chance that there will be a lot of blank cells too but I'm only interested in the ones with text in them. How can I pull all the data out into a vertical range on another sheet?

I've been frying my brain on this for days...lol...so any help on how I can do this would be greatly appreciated

Thanks in advance,