Search results

Hi guys. I have a template 40 rows long and 12 cols wide and I would like a number of the cells in it to be capitalized so that when I fill it out the text in these cells show as capitals. I understand that this is difficult as Excel has not allowed for it but has anyone worked out a solution...

Hi, Nebu helped me with a formula two years ago which we use extensively. It puts surnames and first names in a configuration that I use to sort names in a data base. But it has always had a bug. For two years I corrected it manually but our database of names is now larger and requires many...

Hi guys. I recently updated Office from 2010 to 2016. I use Win10 x64. For all customers we type in their address which includes their email address. All details are typed in individual cells. When we enter their email address it would previously (in Excel 2010) automatically create a hyperlink...

Hi guys. My CPU failed, did several stop/starts. I use hundreds of comment boxes in an excel spreadsheet. It changed the text in all the comment boxes to a strange font. I understand comments can be formatted individually in Excel but to change the default setting it must be done in Windows. In...

Hi guys. I notice some threads on other sites about this but none were helpful. I have a large file with many worksheets. There are lookups, macros, plus many other formulas in them but no pivot tables. I did the usual save last night and on opening today all my numbers had been reformatted to...

Hi guys. I have an accommodation business. The attached file shows part of our excel booking system. The numbers indicate cabin numbers and where a cell is hashed or coloured it means that that cabin has been booked for that day. Empty or white cells mean that the cabin is vacant. I routinely...

Hi guys. I can't seem to find an answer on this. I need a VLookup formula so that if any text at all is in the target cell it will return the word Reg. Could you help me with this please? Thanks Mal

Hi guys. I am using Excel 2010, 64bit. I have an xlsm file which has numerous formulas and macros. When starting it I get a warning: Edit Link. Error Source not found. I enclose a screen dump of the error with two screen clips in it. The warning is originating because it is looking for the file...

Hi guys. I have a worksheet which I use for inputting customer information. It is named “Data”. On another worksheet (Names) I have a list of existing customer names. There are 13 rows which display Comments, Notes, Surname, First name, Address, Suburb, State, Post code, Phone, Mobile, Email...

Hi guys. Can you give me the conditional format please. If cell C24 contains a number which is equal or greater that 1 then I want cell D4 to display the word SHEETS (bold) and colour that cell (D4) a light blue. Thanks MalR

Hi Gurus. I have an Excel file which contains a number of worksheets. One worksheet has a database which goes across the page and I add to it regularly with new customer information. It is large and contains a series of repeated blank template tables. It is in a specific worksheet named...

Hi guys. I read the section on pasting but it does not answer my question. I have a row of blank cells with a specific border on them. I need to paste this row into several places in my table. I am trying to do it in one operation using CTRL rather than by repeatedly using the paste border...

Hi guys. Can you help me with a macro that will place data into specified columns so I can import it into a card file in MYOB. Basically I paste a row of data into a worksheet but I need the macro to take this data and line it up in with certain columns as shown. I enclose a file to demonstrate...

Hi guys. On our web we daily inert a 5 page excel file. Done by saving it as a 97-2003 workbook in order to get it to display in IE and saving using the transpose function to get it to run down the web page. I manage the web using Joomla under content Management. All that is fine and it has been...

Howdy guys. We have a booking program done in Excel 2010. (Win 7, 64 bit). When people book we designate the length of stay by colouring the cells. The next lot of customers get a different colour so we can see where the changeover occurs. So we have 14 columns (cabins) containing different...

Hi guys. I assume this has been answered but I cannot find it here. I am using Win7 Ultimate 2009, 64 bit and running Excel 2010. My excel files are saved as xlsx files. I need to change one of them to an xls file in order to get it floated on my web (Joomla). The options to convert the file are...

Hi guys. I use comments a lot. The template comes up with "User" showing at the top. I would like to remove the word user and put in some dialogue of my own. Thus when I call up any new comment it will have that dialogue in it. Effectively this will be my new comment template. I do not want to...

Thanks for a very helpful site. I read your tips on hyperlinks. Can you show me if it is possible to click on a hyperlink in excel and create an email using a template? By this I mean we create a data sheet of names in excel which includes the email address. We are an accommodation business...

Hi guys. Can't see this in the forums. We have a tourist park. I use a home made booking calendar which has daily dates going along the top of an excel worksheet extending left to right. (say row 4). Below this are rows for our cabins. So we have therefore dates extending along the top and...

Hi guys. I have several drop down boxes in Excel 2010. There are instances where I need to add a different number than what is listed in the table for the drop down box. I realize this can be done with code but is there any way (more simply) that I can add these numbers without the "value you...