Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PLEASE HELP: how to Identify a row and populate the data respectiv
Hi All,
Is it possible to populate the same row twice? Same row but different columns. For eg. Lets say A,B,C,D,E are the columns and 1, 2, 3, 4 are the rows. Is it possible to populate A1, B1 and C1 when we click "Accept" button and later when we click "Accept: D" or "Accept: E" it somehow populates in the corresponding row but in column D and E respectively. I think what I am looking for is a way to identify a row and input the data in D and E. How can I design a script that prompts me a window to ask me which row I want to populate in? Lets say I have a Unique ID in Column A and I want a window to be displayed asking me the "Unique ID" to identify the row. So Once I input the Unique ID it identifies the corrensponding row and populates in Column D and E accordingly. Hope I made it clear Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
De-identify data | Excel Worksheet Functions | |||
Identify last row of populated data | Excel Worksheet Functions | |||
identify duplicate data upon entry of that data | Excel Discussion (Misc queries) | |||
identify different data in two columns | Excel Discussion (Misc queries) | |||
Compare and identify new data | Excel Programming |