Search results

The actual spreadhsheet contains sensitive information but here is a sample: https://dl.dropbox.com/u/90990975/sample.xlsx Does that make sense to you?

Hi, A friend of mine has passed on a problem to me He has a massive survey spreadsheet, one of the questions people responded to was: What is the reason for hospital closure? There are 15 possible answers, numbered 1 to 15 So users typed in 1 for the answer But there may have been more...

Hi, can anyone point me in the direction of a tutorial on creating forms for data entry in excel. I've a spreadsheet where I want to insert a button called "new entry" clicking on "new entry" will open a form and from there I want the user to enter data and click submit. After that the...

Hi Kaushik, As it stands Excel uses forms based on column headings, is it possible to create forms based on row headings? Thanks Kevin

Hi, I see that in Excel it is quite simple to design a form using column headings, but what if my table is more practical with row headings? I am attempting to create a simple database in Excel, can I design a form using the ROW headings?

Thank you, I think that maybe my work network restricts access to these sites I will try later from home Thanks again

Thank you but I cannot seem to access this file in your link, can you save it to the drop box folder I posted?

Any assistance greatly appreciated. Thank you

Hi, I am a member of a tennis club. We are looking at creating a very simple tennis court booking system. Members will arrive in to the club sign in to the tennis club computer and sign in to a court. There are 9 courts. All games begin on the half hour or hour and courts must be vacated...

Hi Luke, I would need the individual staff workbooks to be secure Do you know if it is possible to password protect folders in Windows and place each staff member's workbook in a password protected folder?

Hi, I am creating an attendance sheet for staff for 2013 Each staff member must enter their hours for each week of the year in their individual workbook. Each staff member's workbook is linked to a master workbook where the manager can see at a glance who is in, who is out and when people...

Hi, I've a large one worksheet workbook and I want to change one thing in a formula which is copied across hundreds of cells. But I only want to change this in certain selected areas. But when I use the find and replace option I do not have the option to look in a selected area. I can...

Hi, is there any way to retrieve a macro deleted by accident? Thanks

That is cool thanks But this brings me to another question Say for example I have a word doc in cell A2 And this word doc is a template document, it is a contract And I have entered the contract variables in the excel file under relevant heading (name of person, address, contract start...

Hi, is it possible to insert a link in an excel file that will open a document For example I have a group of students, one worksheet per student John Doe Jane Doe Bruce Wayne Clark Kent Within each worksheet I have exam results for each year of their studies I have scanned a copy of...

you are a legend, that works. Thanks kevin on earth

.....could anybody direct me in the right direction: I want to be able to automate the process of creating folders and sub folders. Can I do this in VBA or how can I do it For example if I have a folder called 2013 can I then populate that folder with subfolders for January February March...

Hi Luke, I've managed to resolve the issue, I was in fact trying to apply names when the names were not in use. It's fixed now, but thank you

Thanks guys for the explanation on all of this, some really useful stuff here

Hi, I am trying to create names of columns by using create name from selection but when I click on apply names I get: "Microsoft Excel has encountered a problem and needs to close. Microsoft Excel can try to recover it for you" Excel closes and then re-opens and everything seems ok...

Hi All, these formulas work perfectly and I haven't had to tweak them!! I am interested to know what the 999 does in the lookup formula? This site is amazing!

Thank you both, I will see if this works for me when I get back to the office tomorrow!

Hi All, I have a list of names and addresses. Each row in my spreadsheet is for one person. The column headings are: ColA ColB ColC ColD ColE ColF Name Address Address1 Address2 Address3 Address4 and other information in further columns I need to insert a new column...

Okay thanks, all I need to do now is modify this excel macro to suit my needs!! It will take me a while But it's a start. Thank you

Hi All, I work in HR and have an excel database for our Employees It contains the employees name, address, rate of pay, contract start and finish dates etc. At present I generate contracts and other documents by using mail merge; merging a word doc with my excel database. However things...