Recent content by terrydennis

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...

Istyak Aaahh ! That's the way to do it !! Easy when you know how , eh ? Many thanks ! Just a question of how to adapt your technique into my spreadsheet. But many thanks to those who also contributed. Regards Terry D.

Hi Narayan I have resolved the problem to my satisfaction after a lot of thought and trial and error ! I inserted a text box in the worksheet then inserted the cursor within the text box. Then clicked on the formula bar , typed in = , moved to the cell that contained the text , date , value...

Narayan Thanks for that but I do not understand how to do it ! Can you give me an example of how you think it would work ? Is it clear from my question exactly what I am trying to do ? Thanks in anticipation Terry

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...

Narayan I have read your email as above and tried on two occasions to reply expressing my thanks to you and posing another question which is at the top of this new thread.

Somendra I am sorry but the file that you attached does not show any expressions to answer my question. Am I missing something ??

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.

Thanks for that , Narayan ! I have printed out two of those references you gave and I will have to do some homework ! In the meantime , I have another little teaser in the project I am doing which I cannot get my head round. I am attaching the file for you to look at.

Thanks for that ; it is just the job. The only problem is that I do not understand dynamic named ranges or how to use them or even create them. Is there a tutorial that you can direct me to ?

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...

Sorry guys ! Forget the above post ! I got sidetracked with things going on at home before I had finished evaluating your other suggestions. The Excel Date Picker/Pop-up Excel Calendar is excellent and works a treat but unfortunately , as you are aware , you can only get it as a trial before...

Thanks to all for your time and effort in your suggestions. I guess I may be looking for the impossible. I have opted for the nearest method that I was looking for. I have created a worksheet with a column of 2 years dates e.g 24 Sep 2014 , 25 Sep 2014 etc. etc. and named the column containing...

Yes ! That was one of the many items I came across during my search and found it far too complicated to contemplate ! I am looking for something like simply formatting a range of cells each of which will display a calendar from which one can select a date which will appear in the cell.