Hi there
I want to copy formulas that are in cells d5, i5:n5 down to rows that have non-blank values in column e and/or column f and/or column g. I would like this to happen dynamically so that as soon as a row has a value in any of the aforementioned columns, it has the formulas that are in the aforementioned cells copied into it. So I think that means I need an "event" type macro pasted into the sheet in the VBA project, but I'm not sure.
There are a couple of potential factors:
- row 5 is hidden - I suspect it doesn't matter but I'm not sure
- columns i:n are hidden - I suspect it doesn't matter but I'm not sure
- the workbook has a macro which, when it is manually executed, copies (replicates) the entire worksheet into the same workbook and I need the solution to work for all copies of the original worksheet created by the macro - hopefully the "event" macro will be replicated by the worksheet replication macro for each copy of the original worksheet.
I hope I've explained that properly. Thank you for any assistance.
Stu
Bookmarks