Macro

[DaveAsh]

Hi
I'm currently creating a housekeeping spreadsheet and I need to create a
macro to populate an action plan page when a certain cell is marked 'yes'.

Can anyone help me to do this?

Thanks.

 

[DaveAsh]

I'm really not an expert user but here is the basic info.

I have 3 tabs: 'checklist', 'car parks' & 'action plan'. The sheets
checklist & car parks have 7 columns in the table:
Area Detail Yes, No or N/A M&E Job Location WIP
No. COMMENTS

If the cell for M&E job is marked 'Yes' then I want the whole entry (line)
to be copied to the action plan sheet. The M&E heading is in cell D8 and the
yes/no entry will be in cells D967. The action plan sheet is still to be
created.