Geeks With Blogs

News
Google

Aaron Li's Blog Write it down before I forget April 2013 Entries
How to Copy Formula in Excel
I have a big Excel list with about 40,000 rows(list A), and another list with 3000 rows(list B). I need to find those in list B from list A and remove them. Both A and B have an ID column containg same information.Of course, I think about VLOOKUP() function, but, it could take some time to copy the formula by manually dragging through the 40,000 rows, so here I write this piece of code:Sub CopyFormula() With Sheets("mySheet") .Range("M2:M40000").Formula = _ "=VLOOKUP($A2,SearchRange,1... End WithEnd ......

Posted On Sunday, April 28, 2013 12:35 PM

Copyright © Aaron Li | Powered by: GeeksWithBlogs.net