Hello all!!! Good Evening!!
I have two sheets "INPUT" and "TABLE".
In the Input Sheet I have a Data Feeding Table which has a component called Serial Code, where I give the Serial Code then matching product name appears in row below (used Index/match formula). There after I input manually all the rows below i.e, Var 1 to Var 20 for that serial code.
What I want is I want all that values go and sit in TABLE sheet against the corresponding serial code in their respective columns when I execute a macro.
I then can change serial code and enter new values for that and run the code so that its corresponding values go and sit in Table sheet again.
I am attaching a sheet for clear understanding.
Apologies for any grammatical/language errors. Hope I am making myself clear.
Help me plz.
Bookmarks