Just a quick question for a quicker method for copy and pasting.
Normally I use something like
to copy and pasting to other sheets.. but I find it slow something. The amount of Data varies but usually 30,000-50,000. I was reading online for a faster way and found assigning values would be the fastest way to do this but its usually a set range but my data is different everyday.
How would I go about doing this? Also is it possible to assign the value to more then 1 sheet in one go?
What would be the best method be?
Thanks in advanced.
Normally I use something like
VBA Code:
Range(Range("A5"), Range("A5").End(xlDown)).copy
How would I go about doing this? Also is it possible to assign the value to more then 1 sheet in one go?
What would be the best method be?
Thanks in advanced.