So, I need some help deleting blank cells, or adjusting my code to only copy cells in the range that have a value. Here are the steps:
Copy Range B2:B2000 (which has formulas in it)
Paste the Values of that Range into J2:J2000
Then copy that range however many times the user wants it copied...