I have 2 tabs within a spreadsheet and have been trying to find out how to copy the data from one tab to another.
See my issue..
Tab1
Date range: 01/01/17, 02/01/17, 03/01/17, 04/01/17, 05/01/17, 06/01/17, 07/01/17, etc...
Tab2
Date range: 01/01/17, 06/01/17, 11/01/17, 16/01/17, etc...
Tab1 has all of the data already populated, I am trying to copy the data into Tab2 for intervals of every 5 days.
How can I do a formula to copy the data from every 5 cells from Tab1 into Tab2? Rather than having to manually do a formula to equal each individual cell as I go along?
Any help appreciated, thanks!
See my issue..
Tab1
Date range: 01/01/17, 02/01/17, 03/01/17, 04/01/17, 05/01/17, 06/01/17, 07/01/17, etc...
Tab2
Date range: 01/01/17, 06/01/17, 11/01/17, 16/01/17, etc...
Tab1 has all of the data already populated, I am trying to copy the data into Tab2 for intervals of every 5 days.
How can I do a formula to copy the data from every 5 cells from Tab1 into Tab2? Rather than having to manually do a formula to equal each individual cell as I go along?
Any help appreciated, thanks!