| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find last row in one column and copy + paste data to same row in a
I'm attempting to do the following in an excel macro:
Step 1: - find last row containing data in column X Step 2: - copy the formula from cell Y1 through every cell down to Y* where * represents the row number found in step 1 Can anybody help? Thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
find last row in one column and copy + paste data to same row in a
Sub Auto_Fill()
Dim Lrow As Long With ActiveSheet Lrow = Range("X" & Rows.Count).End(xlUp).Row Range("Y1:Y" & Lrow).FillDown End With End Sub Gord Dibben MS Excel MVP On Tue, 31 Jul 2007 09:08:00 -0700, Eric_G wrote: I'm attempting to do the following in an excel macro: Step 1: - find last row containing data in column X Step 2: - copy the formula from cell Y1 through every cell down to Y* where * represents the row number found in step 1 Can anybody help? Thanks. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
find last row in one column and copy + paste data to same row
That did it -- many thanks.
"Gord Dibben" wrote: Sub Auto_Fill() Dim Lrow As Long With ActiveSheet Lrow = Range("X" & Rows.Count).End(xlUp).Row Range("Y1:Y" & Lrow).FillDown End With End Sub Gord Dibben MS Excel MVP On Tue, 31 Jul 2007 09:08:00 -0700, Eric_G wrote: I'm attempting to do the following in an excel macro: Step 1: - find last row containing data in column X Step 2: - copy the formula from cell Y1 through every cell down to Y* where * represents the row number found in step 1 Can anybody help? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy a column and paste to another tab to save the data for each m | Excel Discussion (Misc queries) | |||
| copy data and formulas from a column and paste into a row | Excel Worksheet Functions | |||
| Find matching date in another worksheet, copy and paste data | Excel Discussion (Misc queries) | |||
| Find last column, move formulas over, copy/paste data | Excel Worksheet Functions | |||
| copy & paste the column found by Selection.Find | Excel Programming | |||
Hybrid Mode
