The company I work for have a large Excel-based Job List for every order we receive. In this spreadsheet there are quite a few hidden cells, which include useful information, but information that doesn't need to be seen all the time.

I'm now developing a new Order Form that will take all the data from the Job List spreadsheet and automatically fill in sections of the OF, to save people from having to write out information twice.

What I want to do is copy EVERY relevant cell for each order on the JL and paste into a data entry section of the OF, including those cells that are hidden on the JL. The problem is when I copy just the cells I need (ie from row A to EA), or the entire rows, and paste into the OF, it doesn't paste the hidden cells from the JL. The only work-around I've found is doing Cntrl-V, Cntrl-Z, Cntrl-V, which then does bring up all the data, but I was wondering if there was just a way to do that in the first place.

I should also point out that the JL is in filter mode all the time, as I know that can sometimes affect things, but the data I want to copy and paste are always in sequential rows.

Any ideas?