i am trying to update the data but it is not updating instead showing the 2015materials

[baig123]

i am trying to update the data(from the TOOL-OUTPUT) but it is not updating instead showing the 2015materials in some other columns

in settings i have listed attribute name9 and attribute value9 from sheet3 to TOOL-PUT i converted them to decimal now i am trying to update that values of (REPLACE VALUE column) to the sheet3(attribute name9 and attribute value9)
whnevere i run macro it shows #value

Please Login or Register  to view this content.

i have attched my excel sheet

[patel45]

Are you working with 2 sheets ? it's not clear for me, You used Sheet3 only for LR

[baig123]

yes i am working with 2 sheets

in tool-output sheet i used list the selected attribute values in then convert them to decimal after that i used replace that values to the sheet3 to the specified attributes value

it will take time for me to replace to specified attribute value

that is why create code to update that replace value to specifed attribute value

Because i have multiple attribute values(column) that is having fractional values


that is why i have used sheet3 for LR
PLEASE HELP ME OUT I AM STRUCK HERE