Hi.
I am new on this forum. Until this assignment I thought I was fairly good at basic Excel and Word.
I have a Form built in Excel (which I must use, as is), that I need to populate many cells with specific data from another Excel spreadsheet.
I tried to Copy the built Form into Word, and tried Mail Merge, but it failed as the Form newly saved in WORD was oversized for the Word page, AND it would not accept the Mail Merge commands for specific areas to load in the Excel data.
SO, I am trying my hand at Using the Excel data to populate the specific cells in this Excel form (I an not allowed to change it) and load over 2000 cells of names, and other related data points into. It isn't working...yet. I need help. I have a deadline of 24 hours now.
Q: Will the Excel spreadsheet data work better if it is converted into Access and somehow loaded into the Excel Form locations? I have limited experience in Access, though I have all my Word, Excel and Access "Step By Step" mega-books at my side.
HELP?!
Thank you!!!
PS: I have a copy of this Form I could attach, but I don't know (yet) how to accomplish that. I am searching for that instruction.
[I am hoping this is the correct location to Post this important question...I am new here, but trying...] I may have posted this on the wrong blog location, earlier today. Sorry.
Bookmarks