+ Reply to Thread
Results 1 to 3 of 3

Help! :) Sorting Multiple Selections, Replace Txt with Pic, Auto Input Form for Users

  1. #1
    Registered User
    Join Date
    02-02-2012
    Location
    Canada
    MS-Off Ver
    Excel 2013
    Posts
    42

    Exclamation Help! :) Sorting Multiple Selections, Replace Txt with Pic, Auto Input Form for Users

    Hello everyone, i got quite a few things i need to get done and i figured i might as well post them all in the same post, if you have any idea about even a small part of what i need then do let me know. Also if you happen to open my sample file and see a way to do something more efficiently please let me know as well. Also, I did some searching of the forums and couldn't find much on exactly what i needed but if i missed something and you happen to know where its located please share the link.

    Before i Begin, My worksheet is too large to upload here so heres a mediafire link for the download : http://www.mediafire.com/?bf4tk7jvbboo3ne

    Sorting Multiple Fields:
    If you take a quick peek at the attached sample file i have you'll see what I'm working with here, basically its like a bill of materials for a job, and its split up into single "tables" (one per paper). What i need for the sorting bit is something that will go through all the "tables" and sort according to any of the 7 columns, but i dont want the "table header" we'll call it to be including in any of the sorting, is this possible?


    Replace Text with Picture:
    Again look a the attached file, you'll see a column that has a few words down it "ANGLE", "IRON" and "TEST", now look at the "Shapes" sheet in the workbook, there are three shapes with corresponding names, what i want is to be able to input text into the column in the "Cutlist" sheet, and then hit a button or something or have a macro run automatically that will erase the text in the column and replace it with the corresponding picture. I believe this will be the easiest way to get what i need to get done, if someone knows of a better way to easily input photos into the correct cells fast, please do let me know.

    Auto Input:
    When looking at the second spreadsheet in the workbook (Cutlist sheet) again you'll notice the separate tables in basically a row, currently the only way to input info into these tables is to manually enter something on each line, what i would love, is to have a single user form maybe on another page or separate application, that would have all the different columns in the table laid out and let the user input the info and when the user hits enter or a button macro after entering the info into that line, the info would be cut form there and pasted into the next available opening in the first table or if the first tables full it would skip the "header" and labels on the second table and post the info on the first available line there. And so on and so forth.

    Sorry for the storybook here but i saw it better then making a bunch of different topics, again any help at all is welcome. Oh and i kind of know how macros work, but i am in no way a programming expert, so if you do post a macro for me if you could just explain what it does or how to use it and ill be able to decipher it from there Thanks so much in advance to anyone with info for me.

  2. #2
    Registered User
    Join Date
    02-02-2012
    Location
    Canada
    MS-Off Ver
    Excel 2013
    Posts
    42

    Re: Help! :) Sorting Multiple Selections, Replace Txt with Pic, Auto Input Form for U

    Scratch everything but the replacement of text with picture, i need some sort of macro that will search a single column for picture codes and when it finds one, pulls the correct picture from either a different sheet or a file, and either erases the tet and puts the picture in its place or places the picture directly on top of the text completely covering it up.
    Last edited by TomToms; 02-06-2012 at 01:42 PM.

  3. #3
    Registered User
    Join Date
    02-02-2012
    Location
    Canada
    MS-Off Ver
    Excel 2013
    Posts
    42

    Re: Help! :) Sorting Multiple Selections, Replace Txt with Pic, Auto Input Form for U

    Anything anyone?

+ 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