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 into a variable
when i press a hotkey each variable which is not null need to be pasted one by one separated by a down arrow key-press
where i am stuck is how to define to paste all non blank variable only
or which approach is fail proof since there may be a maximum of 200 item and sometime i can select a long continuous excel array some time individually cell copy ( i want to select all codes by pressing down control key then all copied cells need to be loaded into macro as a trimmed list ready to be pasted continuously into the erp window one by one followed by down arrow as the erp column will not accept space)
(i want to speed up this pasting process via a com connection if possible but that seems complicated)
i will be happy to get a simple code only the part that able to copy a continuous excel column into separate cell values , and the part only paste the copied trimmed cells values one by one