U
User Personal
i have a table in excel like below
volume ships parameter savings
1x 20 T 1200
2x 25 L 1500
3X 67 T 1400
i need a macro or a form or template where user is asked to enter
volume or parameter and then excel should output the corresponding
savings and ships values fo
for example:::: enter the volume
if user enters the volume 1x, then excel should return the output in
columnar form as follows
For 1x
ships 20
savings 1200
besides the above columns i would be adding other columns. So the
macro or form should ask the user to enter any of the input values/
columns. please explain me how i would modify the
macro to input other columns. If user enters
one of the input values as blank or null , then it should still
extract the output based on other parameter. for example if user does
not enter any value for volume and enters T for parameter,
the output should be
1x
ships 20
savings 1200
3x
ships 67
saving 1400
please advise
volume ships parameter savings
1x 20 T 1200
2x 25 L 1500
3X 67 T 1400
i need a macro or a form or template where user is asked to enter
volume or parameter and then excel should output the corresponding
savings and ships values fo
for example:::: enter the volume
if user enters the volume 1x, then excel should return the output in
columnar form as follows
For 1x
ships 20
savings 1200
besides the above columns i would be adding other columns. So the
macro or form should ask the user to enter any of the input values/
columns. please explain me how i would modify the
macro to input other columns. If user enters
one of the input values as blank or null , then it should still
extract the output based on other parameter. for example if user does
not enter any value for volume and enters T for parameter,
the output should be
1x
ships 20
savings 1200
3x
ships 67
saving 1400
please advise