Automatically Filling Information In Excel Database

[abikau93]

Hello,

I have to do an analysis on an online membership database within excel, but for some reason, some of the cells under the Gender column remain unfilled. Instead of manually filling each cell in, I would like to be able to do it automatically, where a code checks male and female naming dictionary and, if the first name of the member matches a male entry in the dictionary, to enter “Male” or “Female” in the corresponding cell (and if the code can’t find the name to leave it blank – I would elect to do this instead of using, say, the male dictionary and making all names that can’t be found female because some of the names are foreign and probably can’t be found in the dictionary) I do not have any coding experience, so if I could get guidance of some kind (a viable programming language for this task, general outline of the code, how to search multiple web pages, etc) before starting this project, I would highly appreciate it!

[beso]

Like all MS Office applications, Excel is accompanied by the VBA scripting language. Turn on the developer ribbon and click the Visual Basic button.

Searching through random web pages is not viable because the structure of each page must be analysed before any information can be scraped from it. That is an advanced programming skill.

If you could download a list of male and female names it would be more plausible.

However without coding experience you are probably better off just working through the list manually unless it is very very large. There is quite a bit to understand before you will get far.

BTW Excel is not a database. It is a spreadsheet.