Hi Mel

Not sure if this is what you are looking for.

It would help if you can post a sample file with the expected result.

Sunny

Sunny

Thanks for the reply.  Attached is the file.  I hope it helps.  I would like to see if there is a way to combine or expand the CollectDataFromGroup formula to include the Sheet Name as one of the selection criteria.

There is no file attached.

Sorry, this is my first posting.  I will try again.

Hi Mel

Thanks for attaching the file as it better describe your requirements. It is more complicated than what you have described in your post 

I have created another UDF named ExtractData(WorksheetName , Date , GroupNo , RowNo ,IndexNo) that require 5 arguments:

1) WorksheetName :- Name of the worksheet where your data is

2) Date :- The date you are looking for in column A of the data sheet

3) GroupNo :- Your grouping number

4) RowNo  :- The row where the GroupNo are located  (currently at row 16)

5) IndexNo :- The column of the Group that you wanted to extract from (columns 1 to 5 as per your example)

Hope this helps.

Sunny

Sunny,  Thank you so very much.  This is perfect! 

Sunny

I would like to create another extract data table by entering the worksheet name and date.  Then the data will pull from worksheet "DataSheetMorn",

Beginning with Row 449 columns AE, AF, AG, AH, AI, and AJ.  I could not figure out how to modify the previous macro so that it can extract the data.

Can you help?

Thanks

Please attach some sample data and the expected results.

Sunny

Here is the file.

Thanks

There is no attachment.

Here is the file. 

Try this.

Sunny