I am working with Excel 2007. I have created a worksheet which requires a signature to be embedded at the appropriate place. I can insert a signature in .jpg or .bmp format into a spare area of the worksheet but I then have two problems..
1. When I move the image to the area where the...
I have a text box in one worksheet of a workbook which contains the following
"For the year ending 31 March 2014 , the company was entitled to exemption ..... etc etc"
I already have a cell in the worksheet which contains the phrase "year ending 31 March 2014".
Is it possible to insert in the...
I tried to thank Narayan for his references to tutorials in my previous question but it would appear that my two attempts did not work. I hope that this one does and that someone can offer help in providing expressions in the attached spreadsheet.
I have a potential block of data say from B5 to N10. - see attached spreadsheet
Currently , there is data in B5 to I10 with Row 5 containing the date but the data block grows with time.
What would be the formula to put in cells P6 to P10 which will extract the contents of the latest column of...
I have a potential block of data say from B1 to AA10.
Currently , there is data in B1 to Z10 with Row 1 containing the date but the data block grows with time.
What would be the formula to determine the contents of the last column of each row i.e the contents of Z2, Z3 , Z4........ Z10 ?
In...
I have tried searching the web for this answer but everything seems too complicated. I had one hit on a YouTube demo but it was too quick to follow and did not give any monologue.
I have a column of cells (20 -24 different dates) into which will be added a date from week to week. Format should...
I have produced an Excel Workbook which has various macros within it – developed with the help of people on this superb website. However , I have noticed a quirk which I cannot understand and therefore cannot correct ! HELP PLEASE !
The workbook is a leaderboard system for my golfclub which...
Apologies if this subject has been dealt with before. It appears to me that the website does not have a search facility. Am I wrong ?
I have wanted to produce a macro within a spreadsheet which prints out the sheet without using the print preview which is ticked as a default. Having used the...
Index / Match with multiple results
I have been struggling with this for some time and would appreciate some help.
I have been trying to use the Index / Match combination but realise that , because there is more than one line of results for any person’s name , I need to be putting a formula...
I am not sure whether this is the place for this question or not , but I could not find an answer elsewhere.
How can I change my password for this website ?
This is my first use of this website and when I found it I thought how good it was. Here is my problem.
I have been using INDEX & MATCH but struggling to get the syntax for the following scenario. Simplifying will enable my problem to be explained better.
I have a list of names in an Excel...