Good morning all, I have a list of a couple of thousand lines of information. Each line needs to be assigned a building number, a level, and an area. I was thinking the best way to do this quickly would be to user a UserForm with three columns of checkboxes, the three items would be selected and then the next item loaded. But I am not sure whether this would work, if anyone has any advice or comment it would be appreciate, I have relatively little experience with the use of forms.
Last edited by ChrisMattock; 12-16-2008 at 11:29 AM.
Why not just write them in? Why use a form at all?
CC
Add the columns & use Data Validation to select the details
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Well I figure that with so many lines it will take some considerable time anyway, using a form rather than selecting from a drop down box might only save a second a line to enter the data... but for 10,000 lines that could be 3 hours work.
I can't see how a form would be faster than using data validation & doing it manually, it would still be a big task
Excel has the option to autocomplete from cell values which could be even faster than that.
More to the point, if you can group your lines in any way you will be able to batch edit - which has to be an enormous time saver. (we're not just being idle...)
CC
Ok, well I see your point.... maybe I'll run some tests! Thanks guys.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks