Search results

Thanks for all your help guys. I will be tied up for a week or so but wanted to let you know I will be working on it when I get a chance. I have enough information from this forum to allow me to do some experimenting. It was most helpful MalR

Thanks again Narayan. It looks good. I am tied up for a few days so I will try it and get back to you.

Hi Narayan. Good to hear from you again and thanks for another contribution. I have no problem changing to make it easier to do the calculation but to draw borders and colour them involves quite a few stages. They also have to be bold. I am not sure and have not checked but is there a key stroke...

Thanks Jeff. The colours have to be different so we can see physically the start and the end of each booking. If they were the same colour I would have to differentiate the start/end with perhaps a vertical line but it means bringing in another set of keystrokes. (Not impossible if it can be...

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

Thanks Narayan. Exactly what I wanted. I was not aware of ISTEXT. You guys are most helpful! MalR

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

Thanks Deepak. Problem is I only have one workbook. I have a bench top PC. No server. There are links within that workbook. After what you said I found the problem is probably with a table on one worksheet. I converted the table. I tried turning sharing on but it created other problems. What I...

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

Whew! I got it working thanks to you Nebu. There was two problems. The table was named Table 1 in your file and somehow it auto renamed to Table 2 when I copied it across. I did not pick that up. I just checked the name in your file and it was OK so did not double check. The paste...

Yes I am right to go now thanks. Almost. One last thing. I am having great difficulty breaking the links. I have copied your template and MYOB table to a new workbook and it works perfectly. However when I copy it to my booking program it wants to link back to the file you sent. I deleted the...

Thanks but I cannot find the DVs you wrote. I put the ones we use in Database Demo in copied template 738. Seems we both agree that this is the best way to do these. Thanks MalR

Again thanks Nebu. Sorry for the delay. Been busy. I have enclosed a file that answers your questions. I respect that you could have a better way of doing it so I am always thankful to hear your comments. The worksheet has a list of my drop downs. To answer you, I thought these would be quicker...

Hi Nebu. I was unable to work on this for a while Your formulas are working brilliantly and will be saving me a lot of time. Thank you very much! One last thing please. I need to put the formulas into my Booking program to make it functional. The program is called “Booking program.xlsm”. The...

Thanks Nebu. I have been tied up and will get to it shortly and reply to you Mal

That is correct Nebu. How it works is I have the template. Each customer who books in gets recorded in one template. Their data gets immediately imported into MYOB to do the finance and write the invoices and receipts. So MYOB has a very large data base of names and addresses going for the past...

Nebu, I enclose the final file that you need. This is what I use 1 Yes this file has all the fields I need to place in the customer list. There are 10 fields 2 Yes the template is set exactly how I use it. The column widths are also set exactly how I use them. Hopefully you do not have to...

Wow!! Very clever. Thanks! could you tell me what the name of the formula is so I can research it. I wonder if you could now test the program please. I enclose the updated file. I obviously have not understood the next steps because I cannot get it to run. I have put some questions in the...

Nebu I have attached a file with both worksheets in it and with helpful comments written in red in each worksheet. It should answer your questions Thank you MalR

Sorry, my typo. I meant to type Nebu!

Zebu I tried your macro. A problem I have is that my list of customer names extends for over 3000 rows. If I understand your file I have to input them individually which is not practical. I had difficulty getting the macro to work to test it. Obviously I did something wrong. I copied the macro...

Thanks greatly for the effort you made Nebu. It will take me some time to put in the names and test it and I will do this when I get a chance. So far it is very impressive and I will get back to you later. Thanks again MalR

Thanks for taking time Nebu. The file "Names macro" is the template. It is 7 columns wide and it goes down for 36 rows. All I do is copy it across the page so the template of 7 columns gets copied numerous times. At the moment it goes to column KPT and when I fill it up to there I will extend it...

I appreciate your help guys. I attach the sample Names worksheet. My Database worksheet (previously attached) has the same setup but runs down the page so the Names data will be copied and pasted transverse into that Database. Somendra, the target will be surname/initials eg Smith G&S so there...