i want to reply to all
there is a standard item code list of 200 items in two a4 page , the format of it is i had in excel
i will receive the physical written codes in a4 pages all i need to do is select all codes in excel sometimes codes are continuous some time not i need to copy all excel cell codes into the macro code , then when i press it should enter each codes one by one below each line into software erp which is same like excel page.
i need to define 200 variable i think
then there is a space in the end of each excel cell so i need to trim the variable and load each cell value