Good Morning All,
I am working with 2 worksheets. Worksheet 1 is named 08 billings and worksheet 2 is named 08 $ X Job. Worksheet 2 needs to reference various cell values from worksheet 1. I would prefer to use a formula as opposed to paste special, select values, and check the transpose box. Here is my scenario:
Worksheet 1 has data in row 55 starting with column C and ending with column AZ. I am trying to move the data in row 55 from worksheet 1 into a column A of worksheet 2. I have several instances where I will use a different row but remain selecting columns C - AZ in worksheet 1. The data is appearing horizontal in worksheet 1, and my goal is to get it to appear vertical in worksheet 2. Any assistance would be greatly appreciated.
Bookmarks