I have a sheet with numerical data in columns that are non-adjacent. EX Column A and B have data, C and D do not, E and F do, etc. I have data in this order for the entirety of the sheet.
In my second sheet, I'd like to be able to reference the data in columns A, B, E, F etc, in adjacent columns (so column A in sheet 2 refers to column A sheet 1, column B sheet 2 refers to column B sheet 1, column C sheet 2 refers to column E in sheet 1, etc). Currently, I have to do this one-by-one, entering a formula that refers to the specific cells I need.
I am familiar with referencing other sheets, I just need to know the fastest way to basically copy and paste one formula into the second sheet that pulls from sheet one non-adjacent cells.
Any help would be appreciated!!
In my second sheet, I'd like to be able to reference the data in columns A, B, E, F etc, in adjacent columns (so column A in sheet 2 refers to column A sheet 1, column B sheet 2 refers to column B sheet 1, column C sheet 2 refers to column E in sheet 1, etc). Currently, I have to do this one-by-one, entering a formula that refers to the specific cells I need.
I am familiar with referencing other sheets, I just need to know the fastest way to basically copy and paste one formula into the second sheet that pulls from sheet one non-adjacent cells.
Any help would be appreciated!!
