braid76458
New Member
- Joined
- Jun 19, 2015
- Messages
- 1
I have been recently tasked with developing a workbook that will use two sheets (sheet 1) and (sheet 2). Sheet 1 has a list of questions that will be answered, and this will populate a table on Sheet 2 for management to reference.
The issue that has been giving me grief is that when a cell row is reference (Z1:Z250) on Sheet 1 by Sheet 2 and the table is populated with the information, and then that table is copied below, for a new set of questions, the reference for the rows jump in an increment of 7, instead of what I would like, which would be 1, 2, 3, 4, 5, etc....
I understand why the reference is jumping in an increment of 7, this is due to the table, on Sheet 2, being 7 rows, however, I do not know how to make the function to where the reference stays on Sheet 1 rows (Z1:Z250) and only increments by a value of 1. Example Z1.Z2.Z3.Z4 and not Z1.Z8.Z15.Z22
I have tried multiple functions; Indirect, Offset, added Row, and made the reference cell absolute. All of these are lacking some small item, because the cell reference still jumped an increment of 7, except when I made the cell reference absolute and then the formula copied identical but I was unable to get the reference to increment by a value of 1.
To sum it up. I am in need of a function that will look at Z3 on Sheet 1, and populate a cell on Sheet 2. This function needs to be able to copied and pulled down without jumping in increments of 7, because it causes the reference on Sheet 1 to not be able to work, unless I skip 7 cells.
If anyone can offer up any help it would be greatly appreciated. Thanks bunches
The issue that has been giving me grief is that when a cell row is reference (Z1:Z250) on Sheet 1 by Sheet 2 and the table is populated with the information, and then that table is copied below, for a new set of questions, the reference for the rows jump in an increment of 7, instead of what I would like, which would be 1, 2, 3, 4, 5, etc....
I understand why the reference is jumping in an increment of 7, this is due to the table, on Sheet 2, being 7 rows, however, I do not know how to make the function to where the reference stays on Sheet 1 rows (Z1:Z250) and only increments by a value of 1. Example Z1.Z2.Z3.Z4 and not Z1.Z8.Z15.Z22
I have tried multiple functions; Indirect, Offset, added Row, and made the reference cell absolute. All of these are lacking some small item, because the cell reference still jumped an increment of 7, except when I made the cell reference absolute and then the formula copied identical but I was unable to get the reference to increment by a value of 1.
To sum it up. I am in need of a function that will look at Z3 on Sheet 1, and populate a cell on Sheet 2. This function needs to be able to copied and pulled down without jumping in increments of 7, because it causes the reference on Sheet 1 to not be able to work, unless I skip 7 cells.
If anyone can offer up any help it would be greatly appreciated. Thanks bunches