I quite often have to align entries in two different columns, say account
numbers (which so far I do manually). Each account number also has other
(descriptive) data assigned to it in four other columns in the same row -
account value, client name, transaction amount, date. So I have to align
account numbers the way that four cells (with the descriptive data) will
follow the account number and will find themselves in the same rows with
their corresponding account numbers after the alignment.

My lists usually contain, say 100 account numbers on the left(with their
corresponding descriptive data cells) that have to match the same 100 account
numbers on the right, which are listed in a different order on the
spreadsheet before the alignment, (with their corresponding descriptive data
cells).

To explain my problem in simple words I need to match two lists where
account numbers and their corresponding descriptive data cells (10 columns
all together in both lists) will be in the same rows after the alignment.

I guess I probably need to create a macro which would align all identical
account numbers on the lists and would move the descriptive data cells to
their corresponding account rows. I do not know how to do it however. So
far, I created only simple macros using Tools/ Create a New Macro. But this
one, I guess requires some programming in VBA. Can anyone help please ?