

August 25, 2017

Good Morning
I need some help with a spreadsheet that is to pull data from specific sheets. The way I have it set up is not very efficient. I have six workbooks titled, Sheet11, Sheet12, Sheet13, Sheet14, Sheet15 and Sheet16. My question is how would I adjust my formula so that I can have one formula to pull from specific sheet. I enter data in column J and column K and the results is listed in column L. I would like to add Column I for the name of the sheet. So once I enter the data into the appropriate columns the correct data is populated.
Here's my formula. CollectDataFromGroup($J43,"Sheet11",$K43,COLUMN(A1))
Any ideas on how to revise the formula is greatly appreciated.
Thanks Mel


VIP

Trusted Members

June 25, 2016



VIP

Trusted Members

June 25, 2016



VIP

Trusted Members

June 25, 2016

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


August 25, 2017

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


VIP

Trusted Members

June 25, 2016



VIP

Trusted Members

June 25, 2016

1 Guest(s)
