automate fill cells

[imported_unknown]

Hi..
I have 27 columns. In the cell M2, I add a vlookup formula. I have more than 28910 rows of data. How can I automate the column M so that it can run the vlookup formula automatically without doing drag and fill by one row by one row??? Anyone have idea about this? I am new user for excel and not familiar with macros...
Thank you...

Maya.....

 

[plettieri]

a quick and dirty method i use....

You might try copying the cell by holding the 'end' key then involking the 'down arrow' this will get you to the last item in the column...this will copy the formular to all the cells along the way to the last cell in the column... delete the extra cells you don't need.

hope this helps

pll
This message was edited by plettieri on 2002-10-02 21:49

 

[imported_unknown]

Hi..
I tried your suggestion but the rows are too many..and my excel spreadsheet "hang"...I recevied a pop up message telling "Your program not responding.....". Is it possible to write a macro for automate for this drag and fill column M?(I am a new user and still exploring the tools and functions in Excel)

Thank you...

Maya.....

 

[plettieri]

You might try posting a short sample on the board to let us see what your data looks like and the expected outcome you desire...


This helps all who look at it.

We have a lot of experienced users here and a best solution will be found.

You can use the colo utility noted below.

pll

 

[imported_unknown]

hi..
I downloaded html maker..everything is fine until the "click to copy to clipboard"..but it doesnt copy to clipboard (i am using windows xp)...
i need to automate the auto fill for cell M with the formula
=VLOOKUP(L2,[saving_summary.xls]Commodity_code!B:C,2,0)
I can do it by drag and fill but the rows are too many more than 28000...

Thank you..

Maya...

 

[PaddyD]

Hi - a few people are having problem with the 'paste to the clipboard' stage at the moment - Colo / Ivan are looking into it. As a work around, you should be able to paste into Word, then select all the code again, copy & paste to the board.

paddy

 

[imported_unknown]

This message was edited by maya2311 on 2002-10-03 00:50

 

[ThePencilQueen]

You can autofill all the way down a column easily. Just hover the curser over the bottom left corner of cell M2 until it looks like a + sign...then double click, it will copy the Vlookup all the way down the column.