Insert Small Photos Into Excel Spreadsheet?
Oct 20, 2012
Looking for a way to insert small photos into a excel spreadsheet.Would it work with data validation or even a lookup table.The photos need to be inserted every 8th row.Is it best to name each photo?I`m not started yet as i not sure if this is even a possibility but if there are ways i will make an attempt...Maybe a VBA code could automatic insert them when a button is selected..they are 2 columns x 4 rows in size the photos
View 3 Replies
ADVERTISEMENT
May 28, 2010
I use the following macro (found it in a forum) below to insert photos in Column A of my worksheet and it works great!
But I need a MACRO that will load hundreds of photos all down Column A. what code needs to be added in order for that to work? Im just a novice and have been searching for a Macro I can copy that will let me load hundreds of photos automatically.
[Code] ......
View 12 Replies
View Related
Apr 6, 2008
I am not sure whether "embedding" is the right word. Please have a look at this excel file and tell me how to make such a file? .....
View 7 Replies
View Related
Nov 20, 2012
I want to put a hyperlink into an existing spreadsheet (which already has some hyperlinks in) but for some reason that option is now greyed out on my tool bar.
View 3 Replies
View Related
May 14, 2013
I need to insert a drop down box into my spreadsheet, and depending on the option selected, the formula used to calculate the value into another cell changes. How do I implement this in Excel 2007?
To put this in context, I need a list of acids in cell C3. Depending on the acid selected, the formula used to calculate acid concentration in another cell (D3) changes. I need a way to implement this.
View 3 Replies
View Related
Jan 8, 2010
We run a fairly small start-up company and I would'nt mind knowing if it was possible to have some kind of stock control system on 'worksheet1'. On 'worksheet2' have some kind of 'Till Style' GUI interface where you can input the products the customer purchased. And then maybe of 'Worksheet3' have a printable recipet which you can hand to the customer.
Of course the idea would be for what-ever is purshased via the 'Till-Style' GUI on 'worksheet2' to alter the stock QTY on 'worksheet1'.
View 9 Replies
View Related
Jan 15, 2009
Can anyone tell me what the macro code is to do this (at whatever box I have selected at the time)
say my box is selected at E3, then when I click the button, it creates a new row E
likewise for F7, AA1, etc...
View 3 Replies
View Related
Aug 24, 2013
I'm trying to make a excel template that will take a list of names, changes but generally around 100, and randomly separate them into 4 sets of 8 groups evenly.
This grouping would be repeated 4 times, but there are some conditions.
Firstly, the same person cannot be put into a group again with someone they have previously been grouped with.
Secondly, someone appearing in the first or last groups cannot appear in that group again.
I've been trying to do it via some complex cell formulas but they are quickly becoming overly complex and im not sure if it will actually work which has completely demotivated me. Ive not been looking at VBA but am now thinking its the right route. Ive been thinking of having a master list and then have an attribute of who people have been grouped with before during each of the groupings, and also what number group they were in and then checking against that or something, but im not sure if that is the most efficient solution.
I attached an example dataset : demo dataset.xlsx
View 2 Replies
View Related
Jun 26, 2013
I have a file that has been produced using Statistica software. The file is supposed to have around one million rows, and when exported to Excel the file is about 30 MB. When I open the .xlsx file in Excel 2010 only two pages of data appear. The rows also have weird numbering. The first square of the A column is A1. The second is A3833, the third is A6789, then A8161, then A8162, then A8163, then A8164, then A18070.
The scroll button to the left of the screen is long, as if the document was only two pages long. When the scroll button is click-and-dragged a small beige square appears with a row number. This small square seems to be aware that not all rows are shown as it shows many more rows than are visible to me.
View 3 Replies
View Related
Apr 13, 2014
I have 1000s of rows of data wherein there is no space or full stop once the sentence ends and a new one starts. For example,
Original text: Bob is a boyJanice is a girl.
What I want: Bob is a boy. Janice is a girl.
View 9 Replies
View Related
Aug 6, 2014
In the link below, the video shows you can link a photo to a dropdown box. Is it possible to link 2 photos to 1 dropdown box?
[URL] ....
View 1 Replies
View Related
Nov 21, 2013
Im trying to get the SPECIAL NUMBER to rename the photos(Column C) according to their names(Column B) and tried using index and match but some of them are giving me errors..
RENAME PHOTO.xlsx
View 2 Replies
View Related
Mar 23, 2012
I have a master data sheet with four columns, A, B, C and D
Column A has the primary data and B,C,D has dependent data values;
So when I insert a new cell in Column A with cells Shift Down, I want mandatorily new cells to be inserted in the same row in col B, C and D as well so that data integrity is maintained;
View 2 Replies
View Related
Apr 17, 2014
sample worksheet Antligen.xls
I have a spreadsheet that I need to add new rows everytime I have a new client. I a formula in the N column and a formula in the F column that I would like to automatically insert itself into the new rows.
The problem is this: I have arranged my table so that I can look at clients alphabetically, and according to other date... BUT now it wont let me insert a new row when I have a new client!!!
Is there anyway of keeping it so that I can insert a new row into my table, but preserve all of the formulas that I want automatically put into both the F and N column?
Attached is the sample spreadsheet.
View 1 Replies
View Related
Sep 24, 2008
Using excel 2003. Cannot insert command button on a spreadsheet we have. Almost all icons in the control toolbox are unavailable when Im on this specific spreadsheet. Any new documents I open work fine. Is there some kind of protected spreadsheet that wouldnt allow for a button, picture, textbox label to be inserted???
I didnt make the original sheet but am just editing and improving it.
I would really appreciate any advice you could give, I have attempted to attach a jpg showing the greyed out icons in my controltool box
View 12 Replies
View Related
Jul 8, 2014
I was wondering if there is a way to add a text box into a specific part of an excel sheet
I've got a document and want a macro so when I click it it inserts a new textbox from cell E167 to X219
if I can only insert one with size its aprox 90% of A4 size.
I've tried recording one but it does not work.
View 3 Replies
View Related
May 5, 2006
I am trying to create a macro that loops through a spreadsheet, copies data over to another workbook then emails the new document.
I have taken this code from an old macro that I found but cant seem to get it to work.
This is the code
Sub EmailAssessments()
Dim strTempName As String
Dim strForename As String
Dim strSurname As String
Dim strBookingNumber As String
Dim strReportingTo As String
Dim strBookingGivenBy As String
Dim strJobTitle As String
Dim dtmStartDate As Date
Dim strEndDate As String ''Need to use a string as there maybe no end date
Dim strDepartment As String
Dim strTierName As String
Dim r1 As Range ''For loop
Dim intNumberOfRows As Integer ''Count how many rows.........
View 9 Replies
View Related
Jun 21, 2006
Can it be done? Example posted. How was the SWF file inserted into Excel?
Link to the file is at: http://www.onlinebookforsale.com/swfinexcel.xls
View 2 Replies
View Related
May 7, 2009
I can use the MATCH function when i am in excel but i am having trouble getting it to work when i am trying to insert the formula using VBA.
Here is the code i have but it wont even compile........
View 9 Replies
View Related
Nov 29, 2013
I receive a Excel download daily consisting of 6 columns of nine numbers and currently "copy" column 2 and "insert copied cells" into a running spreadsheet. I would like a simple way to have the 9 lines pasted as below rather than as sequential lines.
1
2
3
4
5
6
7
8
9
View 2 Replies
View Related
Jan 21, 2010
I would like to use macros to insert the 'location' of my excel file into the spreadsheet footer. I have the following code already:
View 3 Replies
View Related
Sep 20, 2011
Any way I can open a word doc (template) and insert fields from my spread sheet i can do it with an email.
I have a spreadsheet where I keep customers information on and would like to print a receipts.
View 9 Replies
View Related
Mar 19, 2012
In Excel 2010, is there any way to paste a picture into a small picture/diagram box, and upon double clicking the picture it would explode to a larger size? And I guess double clicking it again would make it return to its original (smaller) size. I would be pasting several pictures into several different picture/diagram boxes and would need this to be a relative reference so that upon selection it explodes the appropriate picture?
View 1 Replies
View Related
Jul 13, 2012
I insert a button in spreadsheet, when I click this button a userform appears with place to input value. I would like to check the entire column (maybe < 100 rows), if there is number exceed the input, then disply that ROW in another sheet.
View 1 Replies
View Related
Sep 29, 2013
I am trying to create a macro to insert monthly P&L figures into a spreadsheet.
I am needing the macro to insert a column to the left of a column titled 'movement' each month and copy&paste my monthly figures in.
I have recorded the below macro but my inserted column is always moving into column E and pushing the prior month to the right, where I need it to always be situated to the immediate left of the movement column, e.g. if the macro is inserting September P&L data I need it to be situated between August data (currently in column E and movement data currently in row F and so on.
Column C D E FItem
July
August
Movement
Fees
26,500
28,000
2,000
Assets Ongoing
150,000
160,000
10,000
Columns("E:E").Select
Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove
Sheets("P&L Current Month").Select
Range("D11:D127").Select
[Code] ...
View 1 Replies
View Related
Oct 7, 2009
I developed a 14-day work schedule and I assigned each different job position a number. The different job positions are numbered 1-6 and are as follows: #1=5:30am-1:30pm, #2=6:00am-2:00pm, #3=9:30am-1:30pm, #4=12:00pm-8:00pm, #5=1:00pm-8:00pm & #6=6:00pm-8:00pm. Numbers 1,2,4,5 clock-out for a 30 minute lunch break, while the other numbers do not.
My goal is to insert the numbers 1-6 into the spreadsheet throughout the 14 days for each employee, and have Excel calculate the total number of hours for each employee in the far right column. I would also like "V" & "H" to equal 7.5 hours. This would save a lot of time instead of going through and adding up the hours with a calculator
View 3 Replies
View Related
Jul 25, 2007
I have 2 workbooks open, one called "Temp" and the other called "CRM 2"
My active workbook is "Temp". I am trying to insert a value into the active cell in this workbook, based upon the value of a checkbox in the other spreadsheet. Here's my
If Windows("CRM 2.xls").SelectedSheets.CheckBox6.Value = True Then Selection.Value = "By Phone"
I've tried variations on this such as:
If Windows("CRM 2.xls").ActiveSheet.CheckBox6.Value = True Then Selection.Value = "By Phone"
View 8 Replies
View Related
Dec 2, 2008
I'm having trouble trying to come up with a way to insert data fields into a spreadsheet form. I have a travel authorization form that I would like to have automatically fill in the required fields based on typing in a name. i.e. I would type in an employees name, and it would automatically fill-in the correct address, etc for that employee. I have attached a spreadsheet that contains one sheet as the form, and another sheet containing the employee data. I know nothing about VBA, but I have a feeling that is where I need to go.
View 3 Replies
View Related
Jul 18, 2012
Here is the scenario:
I have a primary excel spreadsheet that I work from. The architecture is as follows:
Sheet 1: Called "Information"
Column A: Name
Column B: Date of Birth
Column C through Z: Various bits of information.
Sheet 2: Called "Master"
Cell B1: Contains the date and time of last update from the VBA I am asking for below.
On a weekly basis I get sent a "Update" spreadsheet that is constructed the same way as my primary. This is what I would like to do with some VBA:
From my primary sheet I run the VBA and it opens a pop up that allows me to select the updated worksheet. Next it cycles through both worksheets (Primary and Update). It compares Column A and B, if it finds a match it updates columns C through Z from the "Update". In order to get a match cell A1 and B1 of the primary worksheet has to match Cell A1 and B1 of the update sheet exactly.
The second thing I would like it to do is if the update sheet contains a new entry...in other words the update sheet has a row that does not match the primary it copies the row from the Update sheet to the Primary. In this way, the Primary sheet is always growing with new information and updating any old information it matches.
The last thing I would like to do is copy the current date and time after the comparison is complete to the Primary workbook to sheet "Master" in cell B1. This way I always know the time and date of the latest update.
View 1 Replies
View Related
Feb 24, 2009
My specific question is:
I have a spreadsheet that I have developed specifically to help with different bank criteria and the processing of loan applications for my role as a mortgage broker. How can I set this up so that if I let someone use my spreadsheet on their pc that it can't be distributed and used by other people?
Further background:
The spreadsheet, to be fair, is not that complicated, and I am sure basic by a more experienced persons standards. But it takes into account the tax rates, investment loans, rates and payments for a range of banks and has taken time for me to produce. So if people are going to want it then I would rather protect my time and interests with a license or something?
Could I put in a hidden formula that links to a file stored locally to identify preferred users laptops?
I am interested in learning more about making the spreadsheet more advanced perhaps, but don't really know where to begin to learn how to do so.
how to advance my skills or the protection of the work done,
View 9 Replies
View Related
