Copy corresponding Cell data into blank cells after applying Auto Filter in a Macro

Hi,

I've applied an auto filter using a macro that currently filters my data on blank cells and then fills the blank cells using todays date. This works great.

I now want to run the same macro, only instead of inserting todays date in the cell thats blank I want to insert the corresponding value from another row / cell.

The number of rows in the spreadsheet(s) will always vary.
The Column where the data is to be copied from is "D".
and the Column being filtered on is currently "H"

Please Login or Register  to view this content.

I've played about with offset and recorded a macro but for the life of me can't get it to work.... any ideas?

Cheers

How about:

Please Login or Register  to view this content.

Cheers yudlugar.... that worked a treat

okay - so i might have been a bit over eager in marking this one as solved.

It works fine on one sheet - I have 2 issues with that i cant seem to solve..

1) I'm looking for a wee error handler that will let it bypass a sheet if there are no blank cells - seems not to like this
2) I'm going to run this as a call procedure on multiple sheets so need to be able to do that... is there an easy way to add in appropriate worksheet references for unlimited worksheets?

Hope i'm making sense..

Here's the code I'm running just now so you can see where I'm going with this if it helps...

Please Login or Register  to view this content.

Please Login or Register  to view this content.