images

Hi, I developed a large database in excel(sheet 1). My objective is to extract only specific data and images (sheet2) from this large data (sheet 1). I used dget function to extract data, but dget function does't work to extract images as they dont have any cell address. Above is...

Hi, I have a financial plan that i am working on, unfortunately i am stuck with a REF! error. https://imgur.com/a/uDLJU https://imgur.com/Pn3bE8r Here are some images, can someone try and help me out with this. Thank you in advance

Hi, I have few images in a sheet called 'Images'. Once the userform initializes, i want the 1st image (Picture 1) from the 'Images' sheet to be uploaded in the userform. I have written the below code. However getting error. Any help would eb appreciated Worksheets("Images").Select...

Hi, Is there a formula for pulling images into excel? The images are either in another excel spreadsheet (ie. I could do a vlookup, but to pull the image in) or the images are located in a particular folder. Thank you.

****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;"> <tbody style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit...

Hi, I'm doing large mail merge with lots of pictures, and I used macropod advices (thanks macropod), but I have problem when I need to send created word document to someone. It has no images. I'm using Office 2016 (Win). Here are my VBA code and formula for placing images. Images, source excel...

Hi everyone. I don't know if this is possible but thought this would be the place to find the answer! I have a table with 4 columns and 30 rows, and one of the columns is for images (so an unique image in each of the 30 cells). Is it possible to have a slicer display the text in the first...

Hi All, Been looking around the site, tried a few things and can't find a way to get this working So time to ask for some help / establish if what I'm trying to do is even possible :eeek: So, I am looking for a VBA Macro that will insert the latest image from a camera directly into excel -...

How can I auto fit images in existing cells in a Column ?

Hi, I have Column A with image names and column B with images. How can crop images (Up=0.5 cm , down= 0.6 cm, left = 1 cm, Right 1.5 cm) and save the images in a folder with file names in respective rows. Some cells can be blank in between. I have 1.5 k rows.

If I have images through B1:B10 and values in A1:A10, what's the best way to delete all images and left value whilst keeping all the values in C onwards to remain in the exact same place? I only want to delete adjacent cell if an image is there so something like this but this really messes up...

Hello everybody, Im really new to VBA and Excel and my question might have been asked like a thousand times, however I still didnt manage to complete my goal. Hopefully you can help me. What I want: I want to show images in a cell based on a filepath. Lets say: A1 = Flower A2 = Dog B1 =...

Hi, I am trying to create a form that people can edit. Users will use various shapes and images in a range to create a diagram and I want to save it to a table in another worksheet. The code below almost does what I want except it pastes the group of shapes as a picture. I would like to be able...

I need to have Excel display images based on the file paths from another column. In a certain way: column G shows the name of the folder column H shows the name of the file(usually: 00, 01, 02, ...) column I specifies the filetype ONLY if it is different from .jpg The image should appear in...

How to select all images in a single excel column ? I have images in cells of column A, B and C. And I want to select only c column images.

Does anyone knows how to solve the below question???? I've been stuck at this question for WEEKS. Kindly help!!!!! The slot machine is a favorite among many patrons in casinos and private clubs. It has three identical reels, each reel with spots for 64 images.These include cherry, plum...

Hi Guys, So I've been struggling with this all day and reached the end of my knowledge as I know there must be a much simpler way of doing it ... Aim Save the current sheet as a seperate workbook with only values, formatting and images i.e. .xlsm to .xlsx (no macros or formulas) Whilst keeping...

Hi Guy's..... I'm Stuck!! Basically I am making a template for a report generator. The reports contain several images, the images are stored in a file tree that will be the same for each report just the master folder different. The issue is that the image name is not always the same. I want to...

I have a spreadsheet with a few dynamic images and dropdown lists on Sheet1. The lists are all in column A, and the dynamic images(Picture 1- Picture 4) are all in column B (1 per row). The table of imagesthat acts as the basis for the dynamic images is on Sheet2. I have a namedformula...

Hi experts, Hope someone can help with this. I have 10k images named as AA-1000.jpg or AA-1000-10.jpg etc. The important thing is that I want to create folders based on first 2 letters in image names, and move all other images with same letters to the same folder. Basically, I want to run a...