If i were you and have access or filemaker around I would try those first.

Regards,
Cesar Zapata


golf4 wrote:

Hi, everyone -

Starting up a new work project voluntarily (scary --- I know). Some
people I've talked to say that Access is the way to go on this one,
but I really feel more comfortable with Excel. So, I'm gonna give it a
shot.

The project includes building a rent comparability database. I work
for a large public housing authority where the requirements state
that, before approving a family to rent a Section 8-assisted unit, we
must evaluate whether the rent, type of unit, unit size, etc... is
comparable to what the proposed Section 8 landlord is proposing to
rent on the program.

I have already taken a number of initial steps: Sheet 1 includes a
userform with about 30 textboxes that I want to use to enter the
existing rent comparability data we have located in a number of
binders. Sheet 2 now has the columns built for each of the 30 items:
Comparaility #, Unit Type, BR size, Rent, Rent Change Date, etc.... I
alo have created 2 command buttons, within the userform, that will
close the userform and one that I would use to load the entered
textbox data into Sheet 2's columns. (GEE, didn't want anyone to think
I'm gonna ask you guys to do EVERYTHING!!!)

SOOOOOO, the first question I would ask is help on VBA code that I can
use is, after I enter the applicable data in all 30 textboxes, how I
would (1) load the data into Sheet 2's rows and (2) have the code
enter the data so that it is loaded row after row moving down Sheet 2?

I do realize my posting is sizable, but I wanted to give as much info
as I could without having my fellow posters nod off.... :)

I really appreciate the continued assistance I get from everyone here
on my projects.

Thanks,

Golf