Macro to Combine Data from Multiple Sheets

[ashringg]

Hi!

Wishing you all a Happy New Year!

This new year- My goal for this year is to ask for help and to understand macros and formulas more but since my workbooks seem a little tedious. I wanted to reach out because I have this extensive workbook with multiple formulas but I'm sure there is a macro that can just fill this info out instead of the formulas.

I tried to use fill from sheet2 and then use vlookup to get the data from the other sheets.

Is there a macro that can fill all the rows from Sheet 2 to be the leading data (SHEET 2- Column C), then to use that data to grab the specific information from each of the corresponding sheets i wrote out. Can you please provide any solutions or suggestions that may help?

Blank Reports workbook.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI
1	Actual Column:	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH
2	Sheet1 (COMBINED- Format):	Date Due	Member ID	Alt Member ID	Participant Name	Mutual Member	Date of Birth	Medicaid Number(s)	Intake Status	Site	County	Language	Certification Period	Assessment Type In CC	Care Plan Due Month	CL RN Assigned	Reassigned from	UAS Scheduled Date	Status	UAS Completed Date	OOA Assessment Entered in CC (Date)	Leave Date	Expected Return Date	Return Date	Cross Reference	Comments	Disenrollment Date in CC	Address	Primary Contact	Most Recent Assessing Org	Most Recent Assessment Finalized Date	Zip code	Most recent Comprehensive Completed Date	Type of Case	Enrollment Date
3	Where Data is located:	SHEET 4-Q	SHEET 2-C	SHEET 3-A	SHEET 2-L,SHEET 2-M	SHEET 2-S	Date Due-F	SHEET 2-E	SHEET 4-N	SHEET 3-P	SHEET 2-O	SHEET 2-P	SHEET 4-Q	SHEET 4-O	=SHEET 5-A+ month(6)				SHEET 4-Y	SHEET 6-F		SHEET 2-U					SHEET 2-K	SHEET 3-J	SHEET 3-M	SHEET 6-A	SHEET 6-B	SHEET 2-N	SHEET 6-C	SHEET 6-D	SHEET 6-E
4	Based off of:	memberid	memberid	memberid	memberid	memberid	memberid	memberid	memberid	memberid	memberid	memberid	memberid	memberid	AltMemberID from memeberid	memberid	memberid	memberid	memberid	memberid	memberid	memberid	memberid	memberid			memberid	memberid	memberid	memberid	memberid	memberid	memberid	memberid	memberid
5	Column Title in the corresponding sheet:	Due Date	Memberid	AltMemberID	lastname,firstname	Mutual Member	DateOfBirth	Medicaid Number	Intakestatus	SubProgramName	SubProgramName	Language1	Due Date	Cert Period	BASED OF ALT= DATE PROVIDED + 6 MONTHS	MANUAL INPUT OR STATE SITE	POST CURRENT MONTH PRIOTY IF POPULATEDON SHEET 4	FROM EXTERNAL DATA FROM NURSES	Status	SITE WEBSITE	= columnU minus 6 Months	OOA Departure Date	searched individually	searched individually			Disenrollmentdate	Address	PhoneNumber	SITE WEBSITE	SITE WEBSITE	Zip Code	SITE WEBSITE	SITE WEBSITE	SITE WEBSITE
COMBINDED REPORT (3)

 

[Kerryx]

Also look at power query great tool for merging and handling large data sets

 

[ashringg]

Also look at power query great tool for merging and handling large data sets

Let me try to play with that! Thank you for the suggestion.