Forum Discussion
Solved
How to copy a certain number of cells based on a value?
Hello! I have 6 columns of timestamps, with numerous rows, if I want to only copy (by random selection) the number of cells in each row, by a given number (in column 7), pasting the data starting...
See the attached demo workbook. It uses dynamic array formulas, available in Microsoft 365 and Office 2021.
Thanks to both of you for your responses!! I am so grateful! You've saved me a ton of time!!! Both answers are great! I marked the one that is the easiest for me to use but wanted to point out that both are great! Thanks again!!!!