Merge Excel Data into Excel Form

%3CLINGO-SUB%20id%3D%22lingo-sub-1944504%22%20slang%3D%22en-US%22%3EMerge%20Excel%20Data%20into%20Excel%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1944504%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20an%20XLS%20Tab%20with%20data%20types%26nbsp%3B%20like%20Well%20name%2C%20Permit%20%23%2C%20Location%2C%20etc.%20that%20needs%20to%20go%20into%20a%20State%20Regulatory%20Form%20that%20is%20an%20excel%20sheet.%20The%20state%20requires%20that%20each%20well%20be%20filled%20out%20and%20saved%20as%20the%20Permit%20number.%20Now%20I%20have%20~600%20rows%20that%20need%20to%20merge%20into%20about%207%20fields%20in%20random%20order%20and%20location%20on%20the%20form.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20merge%20unique%20data%20from%20a%20%22Data%22%20tab1%20into%20the%20%22Form%22%20tab%20and%20create%20either%20a%20new%20file%2C%20tab%2C%20or%20other%20merged%20XLS%20by%20some%20other%20means%20of%20cut%20and%20paste%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1944504%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1945086%22%20slang%3D%22en-US%22%3ERe%3A%20Merge%20Excel%20Data%20into%20Excel%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1945086%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F887075%22%20target%3D%22_blank%22%3E%40deuce616%3C%2FA%3E%26nbsp%3BThe%20form%20in%20your%20file%20is%20protected%2C%20so%20you%20can't%20do%20much%20with%20it%20if%20you%20can't%20unprotect%20it.%20But%20you%20can%20copy%20the%20entire%20sheet%20%26nbsp%3Bto%20a%20new%20one%20and%20copy%20the%20Commission's%20logo%20in%20to%20it.%20Then%20you%20can%20add%20Data%20validation%20to%20the%20Permit%20No%20field%20and%20use%20INDEX%20an%20MATCH%20to%20fill%20in%20the%20relevant%20information%20from%20the%20data%20sheet%20into%20the%20Form.%20Started%20doing%20it%20in%20the%20attached%20file%2C%20but%20gladly%20leave%20the%20rest%20to%20you%2C%20in%20case%20you%20decide%20that%20this%20indeed%20is%20what%20you%20want%2Fneed.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello,

 

I have an XLS Tab with data types  like Well name, Permit #, Location, etc. that needs to go into a State Regulatory Form that is an excel sheet. The state requires that each well be filled out and saved as the Permit number. Now I have ~600 rows that need to merge into about 7 fields in random order and location on the form.

 

Is there a way to merge unique data from a "Data" tab1 into the "Form" tab and create either a new file, tab, or other merged XLS by some other means of cut and paste?

1 Reply

@deuce616 The form in your file is protected, so you can't do much with it if you can't unprotect it. But you can copy the entire sheet  to a new one and copy the Commission's logo in to it. Then you can add Data validation to the Permit No field and use INDEX an MATCH to fill in the relevant information from the data sheet into the Form. Started doing it in the attached file, but gladly leave the rest to you, in case you decide that this indeed is what you want/need.