G
Guest
I would like to marry data from two differently formatted worksheets, and was wondering if there was a function that can be used to account for different sheet layouts.
In the sheet I want to copy data to, data is arranged in rows. In the sheet I want to copy data from, the data is arranged in both rows and colums, but there are blank columns and rows that separate data points.
What I would like to do is is create a simple sum formula that would add data from, say, every fourth cell in a row of another worksheet, or every third cell in a column.
Is there any function that essentially creates the relationship =SUM('Sheet2'!$A$1,$D$1,$G$1,...)?
The sheet that I would like to copy from is a huge dataset, so simply deleting columns or rows would take a long time.
TIA for any advice/help.
In the sheet I want to copy data to, data is arranged in rows. In the sheet I want to copy data from, the data is arranged in both rows and colums, but there are blank columns and rows that separate data points.
What I would like to do is is create a simple sum formula that would add data from, say, every fourth cell in a row of another worksheet, or every third cell in a column.
Is there any function that essentially creates the relationship =SUM('Sheet2'!$A$1,$D$1,$G$1,...)?
The sheet that I would like to copy from is a huge dataset, so simply deleting columns or rows would take a long time.
TIA for any advice/help.