changing datas when adding row ?
 

Hi all,

I'm a newcomer in excel and I want to do a sort of "test case
generator" but I'm stuck with a problem, I hope you could help me.

I've cells in a row (containing test case data) that I populate with
"generic datas" trough a dropdown menu. When I've completed all the
cells in the row with all these "generic datas" I wish to add this row
at the end of a list of cases on another
sheet(s) and at the same time change the generic datas into specifics
datas (such as formulas or constant) that I've stored in a specific
location in a sheet.

for example the row test data case (only one row will exist) is the
following : in sheet 1 A1 = guest1 (generic data) B1 = participant2
(generic data) C1 = guest3 (generic data) ... AZxx = guestxx (generic
data)

in sheet2 I've stored my formulas/datas
I've in cell A1 a value wich refer to the guest1 (eg : =x), in cell B1
a formula wich refer to participant2 (eg: =z+5) and so on...

in sheet 3 the result :
the row is added at the end of the last entry and the "generic datas"
will change into formulas/datas (located in sheet 2) A1 =x, B1 =z+5.

Thank you in advance for your help and sorry for my bad english.

Nic.