+ Reply to Thread
Results 1 to 2 of 2

Maintaining Inserted Images in the row qith Corrsponding data for inventory

  1. #1
    Registered User
    Join Date
    07-24-2013
    Location
    San Diego, CA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Maintaining Inserted Images in the row qith Corrsponding data for inventory

    Hello:
    I'm creating a 1000 item inventory list. I'm trying to figure out, how I can insert the image of the product into the Row of data associated with that item.
    When I do a Sort, the data on the rows sort as I wish it to, but the image stays in the old location instead of moving along with the data in the row. The image seems to float above the grids and isn't really locked into anything.

    Not sure if I'm explaining this correctly. can anyone direct me towards a solution?
    Thanks

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Maintaining Inserted Images in the row qith Corrsponding data for inventory

    Welcome to the Forum jefftoons!

    Images have a property that by default is "Move But Don't Size With Cells". That is what you want and is probably how your images are set up. To confirm, right-click on one and select Properties, and see what box is checked.

    If you put data in the cells where the images are located, and include that column in the data to be sorted, then you should get the images to be carried along with the sort. It doesn't matter what the data is, but it seems that some data is necessary. You could put a 1 in every cell. It will be covered up by the images.

    Where are you putting your images and how are you doing your sort?
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Inventory Stock Balancing with Inventory Data
    By bingbangboom in forum Excel General
    Replies: 2
    Last Post: 01-30-2011, 11:06 PM
  2. Code to resize images maintaining ratio
    By simjambra in forum Word Programming / VBA / Macros
    Replies: 2
    Last Post: 08-05-2009, 06:30 PM
  3. Sorting database with images inserted in cells
    By Greywolf in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-02-2006, 01:10 AM
  4. Maintaining data integrity - need help
    By teak615 in forum Excel General
    Replies: 0
    Last Post: 03-16-2005, 01:50 PM
  5. Need help qith formula
    By cynder77 in forum Excel General
    Replies: 5
    Last Post: 01-24-2005, 01:03 PM

Tags for this Thread

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