Thread: Recalling sets of formulas across a row?

Ok, I'm sort of a newbie to Excel, and I'm wondering if I can do something....

I'm doing a data entry gig entering royalty information for an musical artist management company. What I have to do is enter the gross amount, and then apply the percentages across the row for each writer involved to get their stake of the money.

So let's say I do the breakdown for a song called "Anthem". I manually enter their breakdowns, and go on my merry way. Then, 50 entries later, I get another instance of "Anthem". What I need to know is; is there any way to recall the set of percentages I used for that song earlier so that I only need to do each of them once, and apply them if I run into a song again (which will happen, multiple times, for each song I have to cover)

Any and all help would be appreciated.

MattOD

Welcome to the forum, bassguy.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.