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.
|