Work around to 500 row copy and paste limitations

I have a sheet I'm using to vlookup information into multiple other sheets. This sheet is made up of information pulled from another system and has to be updated regularly but it is usually more than 500 lines. Is there another way to get this information copied over that doesn't require me going in 500 line increments?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!