Search results

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

Thanks very much for your help Somendra and Khalid. Your formula is exactly what I was after Khalid! I appreciate your help guys. This thread can be closed now. Regards MaLR

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

I need to sign off on this one. Thanks for all the input guys. Because I need to be able to access another worksheet from anywhere in a separate worksheet I settled on two options. Cntrl+G and the one I am currently using, a hyperlink. In both cases it requires setting a target cell in the...

Guys thanks for your quick replies. Much appreciated. Jake I think your idea has merit but I need to explain my situation so you can advise more on it. This should also answer Jeffrey's questions. We are a tourist park. Our booking program is an Excel program. Our major worksheet is essentially...

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

Appreciate your followup Iferror and I will give your macro a shot Smallman. I enjoy looking at new options that could speed me up. That's why this site is so interesting. You think you have a solution and someone comes up with a simpler method! I will get back to you but it will be later on...

Thanks again for your help and quick responses guys. I could not get the Iferror formula to work. Something wrong with the deliminators. I played around with it but finalized on a very simple solution to get the cells to line up in the columns that I require. I paste/transpose the data into my...

Thanks a lot iferror I am having a look at it. Haven't quite got it to work yet. Sir JB7 thanks also for your offer. You are always quick to respond. Guys, I am trialling the suggestion of iferror and will post a reply at a later date. I appreciate your help Regards Mal

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

Thanks for your help again Sir. I have been quite busy and am not able to spend much time on it at the moment but your suggestion should help. What started my comment was that in Developer/Export, the Export icon was not open. The import icon was available. I see now that I must save the file as...

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

Sir I guess my intention is not getting through to this forum. I strip out all text and formatting from the booking sheet so that I finish with just a series of colours (the rainbow) in a table. The colours designate when any cabin is booked. I want absolutely nothing to show on the web that...

Thanks for your input Hui. For simplicity and privacy we thought it is best to just display the cabin numbers. They are easier to apply to each cell than a name or abbreviation. I just highlight across the complete top row and drag down. It also means that when the customers view it on the web...

Howdy Sir. You should be in the circus. (As the GM, not the clown of course). I won't tell you the name of the global expert who designed the sheet! The dates are like that because I have a Go To Today macro that works off them. And you realize wives like pretty colours. I copy a section of the...

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

Thanks Smallman and Hui. Problem fixed. Regards Mal

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 your help Sir JB7. Our business is in tourist accommodation. Our current process is to put the customer's details into an excel database when they book with us. We take a deposit (EFTPOS) and create a deposit file in MYOB. In Outlook I have a template stored which gives the rules of...

Thanks a lot for the suggestion Luke. I tried that and it would not work. Obviously I did something wrong. The process I used in steps is Copy the template in Outlook and save it as a word doc. Click on the email address in excel and open hyperlink Create a new document File path to target...

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

Narayan thanks for the input and the quick reply. I was using Cntrl F to find the word "Today". Problem is I have to type the word everytime I want to go back. OK for me but for my wife it is another story! SirJB7 this is a brilliant bit of code. It did the job! I had previously used a similar...

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