Copy & Paste data INCLUDING hidden cells? (Excel 2003)

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?

If the hidden cells are contained within hidden columns then Go to tools>options>transition and check transition navigation keys. Use the equal sign to reference what you need to copy and the hidden cells in a hidden column will appear for selection.

If you paste a sample workbook, I am sure people will be able to help you automate the process. Why copy the data when you can just reference it?

I am sure Index/Match or Vlookup will help you tremendously.