I got a question, if i have a specific values from column A of Workbook 1 and then i want to use those values to be append to next empty cell in column B of Workbook 2.
As far as i know, append range seems to be a better option for this issue but the thing is append range properties only have sheet name and data table input name only. So this solution seems like not the best i think.
Could anyone help me on this? Appreciate your help.