I have an Excel Workbook that contains a spreadsheet with multiple rows and columns of data (Sheet B). I have another spreadsheet that I created a form (Sheet A). I want to merge the information from a row in Sheet B to Sheet A then save Sheet A separately. I want to be able to do this with each row in Sheet B to create multiple Sheet A's and save each one separately. Very similar to Word's mail merge using an excel spreadsheet but using Excel. I don't even mind the two sheets being in 2 separate workbooks if needed.
I am truly hoping there is someone out there who can answer this question.