| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 100097 | 2009-05-26 07:18:00 | Excel Help | stormdragon (6013) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 776911 | 2009-05-26 07:18:00 | So here’s what I'm trying to achieve. I want a summary sheet with all a participants contact details, and cells which I can enter a yes or a no in to match an event. What I then want the spreadsheet to do is read whether "Yes" was entered and if so insert the participant’s details in the next available row in a separate sheet for that particular event. Any pointers on how to achieve this? Yes I know a database could be a better solution, but the system on which we wish to run it only has the basics. Thanks |
stormdragon (6013) | ||
| 776912 | 2009-05-26 07:51:00 | Might seem a pointless question, but do the participants stay the same? Or are you going to update that semi frequently? | the_bogan (9949) | ||
| 776913 | 2009-05-26 08:19:00 | Participant details should remain the same but days booked could change frequently and more participants added frequently. | stormdragon (6013) | ||
| 776914 | 2009-05-26 08:43:00 | What version of excel and what's the ram? | the_bogan (9949) | ||
| 776915 | 2009-05-26 08:48:00 | Will be running it on 2003, with 256mb of DDR :( | stormdragon (6013) | ||
| 776916 | 2009-05-26 21:08:00 | Why not use a free database program - eg OpenOffice Base? | MushHead (10626) | ||
| 776917 | 2009-05-27 02:18:00 | Don't have the time to develop a whole database and train users, they already use excel so keeping to it would great. | stormdragon (6013) | ||
| 776918 | 2009-05-27 02:55:00 | I have made small excel databases, but were manual input formula intensive, and become unwieldy to handle. You would have to try a combo of conditional formatting, filter/advanced filter, possibly pivot tables, and the vlookup functions. Then need to run the tools-auditing-trace dependents to check the route integrity of the formula's. Maybe start with the VLookUp function (www.techonthenet.com) (example)... |
kahawai chaser (3545) | ||
| 776919 | 2009-05-29 23:17:00 | Sorry for the slow reply, boss has decided to do a database instead and retrain staff. Thanks for all the replies. |
stormdragon (6013) | ||
| 776920 | 2009-05-31 06:02:00 | Sorry for leading you on there? lol. I had the majority of it worked out, I just couldn't figure out the last bit (The idiot proofing bit). Mind you, has any one managed to create something completely idiot proof? |
the_bogan (9949) | ||
| 1 | |||||