•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Online version, script to copy used range to a new table
Our take
If you're looking to streamline your data management process, copying data from one table to another can be a game-changer. Using the `UsedRange` property is a solid start, as it allows you to identify all filled cells in your table. However, transitioning that data to another table can be tricky. Instead of relying on tutorials focused on filtered rows, consider a direct approach that leverages simple scripting techniques. With the right script, you can effortlessly transfer your entire used range, enhancing your workflow and productivity.
I'm trying to make a script that will automatically copy all the data from one table to another. I am having trouble with the language, I know I can select the entire data with usedRange, but I don't how to get it from there to the other table. I can only find tutorials with filters to add rows based in the filter. Anyone knows how to copy the entire used range, based only on it being filled?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience