Quote Originally Posted by Dhruva101
Bryan, Cool, This works.

Scott, Thanks, this is a very good trick about CTRL+D. Thank you.
About the other things of taking more time. what I do is, my work book has 5 sheets. One is master sheet and the other 4 are look-up sheets. So I need to bring 8 columns into master sheet from these 4 sheets by doing VLOOKUP using the following formula.



Once I am done, I do a little verification and I remove the formula by using the Paste special technique.

This is what takes a long time and many times hangs like anything. Some of the master files are really big.
Now what I do is, I only apply formula per one column at a time and also only for 5 to 6000 lines and then for the next set. So it means if it is a 50,000 lines spread sheet, i need to apply the formula 80 times. 10 times on each column and on 8 columns.. I have more than 50 work books to work on.. Any suggestions towards helping me move faster on this would be great.
Hi,

Once done the 'paste special = values' is good, it will then no longer occupy time re-doing the VLookup.

if the columns are contiguous you can do them in bulk, select all 8 column-formula and Copy, select the range and paste (or bulk-drag the 8 columns down the page.)

with 50 books to go you might find a macro to do each book more appealing.

hth
---