hamistasty
Board Regular
- Joined
- May 17, 2011
- Messages
- 208
(1) I would like vba code to count the cells with values in them of Column A, row 9 downward of tab "schedule", then uses that count to copy and inserts row 13 of tab "index" the amount of times that count gave.
(2) Then the code copies cells from Column A, row 9 from tab "schedule" down until there is no value in a cell of that column (ie. all the non-empty cells), and inserts those values in column C, row 13 in tab "index".
Esentially, this is creating the index row where those values in the schedule are copied from the amount of times that there are values to be copied from index. So it takes the count from the schedule of the cells to be copied, then creates space for them in the index, and then pastes them into that index.
Any help with either of those two lots of code would be a big help! tia
(2) Then the code copies cells from Column A, row 9 from tab "schedule" down until there is no value in a cell of that column (ie. all the non-empty cells), and inserts those values in column C, row 13 in tab "index".
Esentially, this is creating the index row where those values in the schedule are copied from the amount of times that there are values to be copied from index. So it takes the count from the schedule of the cells to be copied, then creates space for them in the index, and then pastes them into that index.
Any help with either of those two lots of code would be a big help! tia
Last edited: