dynamically added rows

i have a spreadsheet where i basically cut and paste 10-12 different access databases, in an effort to compare them.

the problem is that the databases once pasted in do not line up (entry 10 might be entry 11 in one, or it could be entry 9 in another and skip entry 10 entirely)

because of this my spreadsheet is useless. Ideally, i would like something that will insert blank spaces where there are no #'s available and then put everything in place for me

ill attach a small part of the spreadsheet so you have an idea what im dealing with, and what i am doing manually to this entire spreadsheet. the full spreadsheet currently is over 1250 lines long and stretches to CK.

please help!

Hi johnzm
You can change this to suit

Please Login or Register  to view this content.

Insert a header row above your data.

Then select (what are now) A1, G1, M1, and S1, and in the Names box, left of the Formula bar, enter keys

Then run AlignKeys:

Please Login or Register  to view this content.

anyone wanna make some quick cash? i am extremly confused.

email me and ill paypal you 20 bux!!

johnzm@yahoo.com

If you answer my questions I can help for free - and if you want, give some money to ActionAid for me.

what about movember that was a good look