View Single Post
 
Old 12-07-2020, 06:15 PM
indigo1 indigo1 is offline Mac OS X Office 2016 for Mac
Novice
 
Join Date: Sep 2020
Posts: 7
indigo1 is on a distinguished road
Default Automatically populate cell with data from column in sequential order

Hi - i would like to paste a heap of heart rate data in the 'B' column. Then in cell 'E13' choose a particular call to start at (i.e, =B19), and then the cell below that automatically is one below that that (i.e., B20) and so on down to the end of the green shade. The numbering would then continue in Column F, from F13, following the same pattern.I want it to automatically populate when I paste the heart rate data in column B, rather than having to drag the cells each time.

I hope I have explained this clearly. It seems like it would be an easy solution? Thanks for your help, it is appreciated.
Attached Images
File Type: png Screen Shot 2020-12-08 at 2.16.37 PM.png (59.0 KB, 21 views)
Reply With Quote