Keebler
Board Regular
- Joined
- Dec 1, 2021
- Messages
- 182
- Office Version
- 2021
- Platform
- Windows
so i have a collection of every evolving sets of data.
sometimes the data has merged cells, or merged cells with wrapped text, or just plain text.
what i need to learn how to do is to make a live (if possible) copy of the data to another part of the same sheet.
the setup
i have a range (a4:l48)
i need to have an exact copy (including formatting, merged cells, etc) made in range (m4:x48)
VBA is preferred but not required
my attempts to perform this so far have been using formulas and indexes -- it is cumbersome and does not copy formatting. only the text.
any help getting pointed in the correct direction would be greatly appreciated
thank you
sometimes the data has merged cells, or merged cells with wrapped text, or just plain text.
what i need to learn how to do is to make a live (if possible) copy of the data to another part of the same sheet.
the setup
i have a range (a4:l48)
i need to have an exact copy (including formatting, merged cells, etc) made in range (m4:x48)
VBA is preferred but not required
my attempts to perform this so far have been using formulas and indexes -- it is cumbersome and does not copy formatting. only the text.
any help getting pointed in the correct direction would be greatly appreciated
