Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
add row to the end of a list and data change
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I change the color of the menu list in a data filter? | Excel Worksheet Functions | |||
How do I change the width of the data validation list box? | Excel Discussion (Misc queries) | |||
monitor cell that uses data validation list for change | Excel Discussion (Misc queries) | |||
Add/Change Data validation list | Excel Programming | |||
Create way to change data in list from another page | Excel Programming |