I have a table of employees which is 60 columns of hire month (60
months) by employee (20 rows). Also in the table are salary and start
month.

I'd like to know how to automatically have a way to (maybe a function
or macro) take the salary amount and plug it into the table once at
the start of the month table plus the start month. This would then be
replicated (by an existing formula in the table) thru the end of the
months.

I know I've seen something like this before, but I'm at a los of what
functions/commands to use to do this.

And suggestions on where to start to figure this out?

Thanks.

Alex Smariga