User Profile
TierM1970
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
Merging information from a worksheet to a form created on another worksheet
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.514Views0likes0Comments
Groups
Recent Blog Articles
No content to show