79598824

Date: 2025-04-29 16:35:52
Score: 1
Natty:
Report link

To duplicate an array of data with formulas in a new position in the same sheet, you can use a duplicated sheet as an intermediate. That is, copy the sheet, then move the data in the duplicated sheet, then copy it from the duplicated sheet into the original sheet. You now have the array in two places on the original sheet, and you can delete the duplicate sheet.

Reasons:
  • Whitelisted phrase (-1.5): you can use
  • No code block (0.5):
  • Unregistered user (0.5):
  • Single line (0.5):
  • Low reputation (1):
Posted by: James Jaynes