Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web form to Excel
Dear All
I have a spreadsheet which contains our media library (it's pretty small and very basic!) Column A contains a catalogue number (eg exa.00001, bk.00023, etc.) Column B contains the name of the person who has borrowed the item I was hoping to make a webpage with a couple of fields so that when borrowing an item, people can simply visit the page, type the catalogue number in one field and their name in the other field. (It would be quite nice if when they press a button the title of the media then showed on screen - but this isn't essential.) Then, when they press a Confirm button, the entries they've made should update on the spreadsheet and the conditional formatting of the spreadsheet should then step in. Can anyone advise on whether this is possible and how I should make up the webpage. Also, if it is possible. What problem might there be if more than one person accessed it at once, or if someone completed a loan on the webpage at the same time as someone was working on the spreadsheet? Thanks in advance. Belinda |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel form. Need data extracted to spreadsheet each time a form co | Excel Discussion (Misc queries) | |||
Can a form made in Excel 2002 be converted into a fillable form? | Excel Discussion (Misc queries) | |||
how to generate a unique form # when using an excel form template | Excel Worksheet Functions | |||
How do I put my information form Excel into a Word Merge Form? | Excel Discussion (Misc queries) | |||
I created a form on excel. want to edit the form without printing | Excel Discussion (Misc queries) |