| well i get big list of addresses....say
Current Resident <first column
3047 Rodney ave Apt. 1 <second column
Ft. Riley, KS 66442 <third column
now for that building alone ill have 6 apartments so everything the same except the apartment # ....for example
Current Resident
3047 Rodney ave Apt. 2
Ft. Riley, KS 66442
Current Resident
3047 Rodney ave Apt. 3
Ft. Riley, KS 66442
Current Resident
3047 Rodney ave Apt. 4
Ft. Riley, KS 66442
Current Resident
3047 Rodney ave Apt. 5
Ft. Riley, KS 66442
Current Resident
3047 Rodney ave Apt. 6
Ft. Riley, KS 66442
then ill have the next building so
Current Resident
3048 Rodney ave Apt. 1
Ft. Riley, KS 66442
so on and so forth....now i know that excel has that nifty little thing were it recognizes #'s and adds one when you pull down....but it adds one to the bldg. # not the apt #...is there i way i can get it to recognize the apt #??
also.....this is really basic, but when im typing and i want to go down a cell, whats the keyboard shortcut...i dont like having to double click to be able to type in that cell!
it would be really awesome if i could figure out how to just enter the first and last in the building # range, and the # of apts then let it fill it all in for me....is that possible? |