Hi,
Im trying to figure this "Offset" in my problem out.
At least I think I should use offset
I know its a simple fix, but Im running out of time to get it solved.
I think I can post my problem without an example attachment, I hope its not to confusing the way I wrote it out below.
Thank You for help in advance,
Problem I have is as follows:
I have "Sheet 1" in excel that has a list of numbers that could be any number "In my Columns"
Example: Column E, Rows 6,7,8,9,10
-141, -132, -137, -142, -131
Ok, In my "Sheet 2" the above numbers are in column C, Rows 6,10,14,18,22
You will notice in "Sheet 2" the Rows of the numbers from "Sheet 1" do not go in rows like "Sheet 1" (6,7,8,9,10)
they will go up every "4 Rows" (6,10,14,18,22)
Also there is numbers in the other 3 rows that are skipped on "Sheet 2" (These numbers are not a problem, except for possibly not showing blank cells in formula"
All I'm doing is transferring numbers from "Sheet 1" to "Sheet 2"
I use the Basic formula for 1st number as =Sheet1!E6 in "Sheet 2" to get number from "Sheet 1" which is -141
But when I copy and paste on "Sheet 2" the 2nd number it will skip the -132, -137, -142 and will paste the -131 which is the "4th number down on Sheet 1"
I understand why it does this, but I don't know how to fix so it will show the 2nd number -132, then 4 more rows down show the 3rd number -137 and so on.
Thank You for Help!
Bookmarks