To be more helpful:

You can get started in learning VBA for Excel by recording several
small macros that do a part of what you need, such as inserting a row
or putting a value in a cell. Then observe the visual basic syntax that
was automatically generated. If you already know a programming language
(loops, if-then-else, etc), then you can teach yourself VBA from a
book.

It's a start --

DH