|
|
#1
12-07-2020, 06:15 PM
|
|||
|
|||
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. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Drop Down List to Automatically Populate Data in a Table
|
src144 | Word VBA | 8 | 12-03-2020 04:15 PM |
| How to auto-populate data based on cell value | ag2686 | Excel | 2 | 06-13-2018 09:19 PM |
|
Automatically Organize data in a sheet differently (in order to create a dynamically updated graph)
|
carlos_cs | Excel | 3 | 05-04-2016 08:44 AM |
| How to populate cells in Sheet2 with Data Source query using cell data from Sheet1 | bobznkazoo | Excel | 2 | 03-27-2014 11:14 AM |
|
Populate Data to another cell
|
Mrkieth | Excel | 2 | 04-29-2013 07:30 AM |
Mac OS X 
Office 2016 for Mac
Threaded Mode