VBA to autofill formula row down to other rows where adjacent column is populated

**jamesr86** · 07-13-2016, 05:18 PM

Hi All

This is my first post.....

I've created a row of formulae from cell E6 to NI6 and was hoping that this row of formulae would be copied down to all rows where column D <> "". I'm trying to keep the workbook to as small in size as possible - the data will never go further than row 500.

When information is added to additional rows in column D could the formula please then run until the new last row of data in column D

I'm very experienced with excel but a near novice with VBA (I'm ok with amending already written VBA but struggle to write from scratch)

I've attached the file, please ignore my feeble attempt at vba

Any help would be much appreciated

Thanks in advance.

James

**1aaaaaaaaaaaaaaa** · 07-13-2016, 06:08 PM

We have to use column G here, because it is the only column where the rest of the cells are blank after your data stops. so we can use WS.Cells(Rows.Count, 7).End(xlUp).Row, 7 corresponds to the column number.

Please Login or Register  to view this content.

**jamesr86** · 07-14-2016, 02:03 AM

Hi

Thanks, it seems to fill the formula down to the end of the spreadsheet rather than just to where the data stops in column d, I'd like it is possible to check the cells in column D (up to cell 500)and if populated copy the formulae to that row from E6 TO NI6.

There is data validation on column d (dropdown lists) not sure if this is causing the issue?

Thanks

James

VBA to autofill formula row down to other rows where adjacent column is populated

LinkBack

Thread Tools

Rate This Thread

Display

VBA to autofill formula row down to other rows where adjacent column is populated

Re: VBA to autofill formula row down to other rows where adjacent column is populated

Re: VBA to autofill formula row down to other rows where adjacent column is populated

Thread Information

Users Browsing this Thread

Similar Threads

Autofill formula down rows, but increment column reference by 3

Autofill formula down rows, but increment column reference

[SOLVED] Autofill Upwards With Reference to Adjacent Column

[SOLVED] Macro to autofill formula down to length of adjacent column to the left

[SOLVED] Macro to calc. #'s btwn variable rows/columns corresponding to an adjacent populated cell

[SOLVED] VBA Code Required to autofill formulated column according to the adjacent column

Autofill a column based on number in adjacent column

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions