+ Reply to Thread
Results 1 to 10 of 10

Solved

  1. #1
    Registered User
    Join Date
    06-25-2013
    Location
    Chicago
    MS-Off Ver
    MS Office 2010, 2007
    Posts
    40

    Solved

    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.
    Last edited by Doc Snowfox; 07-12-2013 at 09:55 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    07-27-2012
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    826

    Re: Excel "Form" I want to Populate with either Excel Spreadsheet Data or Access?

    DUPLICATE POST Original here: http://www.excelforum.com/excel-gene...23#post3295623

    Doc Snowfox, welcome to the forum. Please do not duplicate posts - not only is it against the forum rules, it can result in volunteers wasting their time answering a question that has already been answered by someone else.
    Brendan.


    __________________________________________________________________________________________________
    Things to consider:

    1) You can thank any poster by clicking the * at the left of a helpful post.
    2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
    3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.

  3. #3
    Registered User
    Join Date
    06-25-2013
    Location
    Chicago
    MS-Off Ver
    MS Office 2010, 2007
    Posts
    40

    Re: Excel "Form" I want to Populate with either Excel Spreadsheet Data or Access?

    Brendan,
    I realize that. It seemed I may have put the first one in the wrong place, so I posted this one...and as I am a newbie, it took me up until just moments ago to figure out how to delete the first one. I am hoping I just did that succesfully.
    By the way, no one has replied yet. I am getting very anxious cuz I don't know what the "fix" is yet, and I have to figure it out before tomorrow morning, Wednesday, June 26th, 2013.
    Also, I cannot find yet how to post an attachment...I'd like to put a sample of my Form on my thread, but I haven't figured that out yet, either.
    Thanks for caring enough to write me, if not warn me. I get it. Thanks.

  4. #4
    Valued Forum Contributor
    Join Date
    07-27-2012
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    826

    Re: Excel "Form" I want to Populate with either Excel Spreadsheet Data or Access?

    This is from the FAQ - hope it helps:

    Attachments and Images
    How do I attach a file to a post?

    To attach a file to your post, you need to be using the main 'New Post' or 'New Thread' page and not 'Quick Reply'. To use the main 'New Post' page, click the 'Post Reply' button in the relevant thread.

    On this page, below the message box, you will find a button labelled 'Manage Attachments'. Clicking this button will open a new window for uploading attachments. You can upload an attachment either from your computer or from another URL by using the appropriate box on this page. Alternatively you can click the Attachment Icon to open this page.

    To upload a file from your computer, click the 'Browse' button and locate the file. To upload a file from another URL, enter the full URL for the file in the second box on this page. Once you have completed one of the boxes, click 'Upload'.

    Once the upload is completed the file name will appear below the input boxes in this window. You can then close the window to return to the new post screen.

    What files types can I use? How large can attachments be?

    In the attachment window you will find a list of the allowed file types and their maximum sizes. Files that are larger than these sizes will be rejected. There may also be an overall quota limit to the number of attachments you can post to the board.

    How do I add an image to a post?

    If you have uploaded an image as an attachment, you can click the arrow next to the 'Attachment Icon' and select it from the list. This will be inserted into your post and can be located where you want it displayed.

    To include an image that is not uploaded as an attachment and is located on another website, you can do so by copying the full URL to the image, (not the page on which the image is located), and either pressing the 'Insert Image' icon or by typing [img] before the URL and [/img] after it, ensuring that you do not have any spaces before or after the URL of the image. You can insert pictures from your albums (?) in this way too.

  5. #5
    Registered User
    Join Date
    06-25-2013
    Location
    Chicago
    MS-Off Ver
    MS Office 2010, 2007
    Posts
    40

    Re: Excel "Form" I want to Populate with either Excel Spreadsheet Data or Access?

    Hoping I have attached the sample file. Cell areas I want to link and add/populate data into are highlighted in yellow.
    Attached Files Attached Files
    Last edited by Doc Snowfox; 06-25-2013 at 05:36 PM.

  6. #6
    Registered User
    Join Date
    06-25-2013
    Location
    Chicago
    MS-Off Ver
    MS Office 2010, 2007
    Posts
    40

    Re: Excel "Form" I want to Populate with either Excel Spreadsheet Data or Access?

    Here is a corrected sample file. The Quantity Retrieved cell is NOT necessary, though highlighted in yellow. Thanks so much!
    I don't know why I am having issues getting this to fill and run. I am missing something or over-complicating it. In either case, I'd really appreciate help to get back on the right track. Thanks in advance!

    PS I'd like to DELETE the previously attached file, but can't find how to do that. I see this activity is in the "Go Advance" button. Thanks BB1972 for your help!
    Attached Files Attached Files
    Last edited by Doc Snowfox; 06-25-2013 at 05:38 PM.

  7. #7
    Valued Forum Contributor
    Join Date
    07-27-2012
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    826

    Re: Excel "Form" I want to Populate with either Excel Spreadsheet Data or Access?

    Where are (a selection of) the "2000 cells of names, and other related data points" that you are working with?

  8. #8
    Registered User
    Join Date
    06-25-2013
    Location
    Chicago
    MS-Off Ver
    MS Office 2010, 2007
    Posts
    40

    Re: Excel "Form" I want to Populate with either Excel Spreadsheet Data or Access?

    In another Excel spreadsheet. I want to use the various rows of persons, about 2687 different rows of data, that contain person's names, equipment listed by Serial Numbers and Quantities to populate into the yellow highlighted cells in this sample form. And the person's name, and related Territory Number is to be inserted into the top two lines, as "Field Person's Name" and "Territory Number."
    This is an existing Excel spreadsheet.

  9. #9
    Registered User
    Join Date
    06-25-2013
    Location
    Chicago
    MS-Off Ver
    MS Office 2010, 2007
    Posts
    40

    Re: Excel "Form" I want to Populate with either Excel Spreadsheet Data or Access?

    Brendan, Here is the attachment file for the example Excel spreadsheet to enter into the Form.

  10. #10
    Registered User
    Join Date
    06-25-2013
    Location
    Chicago
    MS-Off Ver
    MS Office 2010, 2007
    Posts
    40

    Re: Excel "Form" I want to Populate with either Excel Spreadsheet Data or Access?

    Unless someone can quickly show me how to populate this Asset Listing Remove Duplicates example spreadsheet into the Sample Checklisgt file, I am going to the Access Forum and try to get this done using the upgraded Asset example file as an Access converted db.
    I cannot figure this one out, and no replies yet that direction either.
    So maybe this is the wrong route to try. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1