What I want to do is to copy multiple lines from a .txt file and paste it into an excel sheet that have hidden rows. Each line on my text file is correlated to the same visible row on the excel sheet.
When I paste the information from the txt file into the sheet, it take into account the hidden lines... half of my data is trapped in the hidden lines.
I've tried the F5 manipulation to only select the visible cells (for the destination) and it's not working ("copied zones and pasted zones have different sizes").