I currently have an Excel row on a Summary Tab that is pulling information from a separate tab. (=”Hood 1′!G12) is an example of one of the cells. Since there are over 800 cells in the row, I’m looking at copying the entire row exactly how it is, except replacing the tab it’s being pulled from, and pasting it in the row below. So that particular cell above would now be (=”Hood 2′!G12) in the row below.
The reason for this is each new tab is data collected for an automotive Hood. The report on each Hood is identical so every cell of data is in the same exact location for every report. Each report is on a separate tab. I want to copy and paste because the row has over 800 points of information.
