I would appreciate help with this problem:
I need to copy columns from another excel files (multiple files) and copy it to the reporting file (one file). I have problem with figuring out how to copy a multiple ranges and paste it always to the last row in reporting excel. Now I have managed to copy the column in the same place, not next free row.
I also tried to copy range to clipboard and write cell from clipboard to last row, but it pasted the range is one cell not in difference rows.
I am a new user, so I am not able to attach files. Thank you!