Macro

D

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

Simon Lloyd

How do you want to achieve it? VBA or worksheet formulae?, what would
the action plan entail? how much data over how many sheets?....etc you
need said:
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.
Click to expand...


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
 
D

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 D9:D67. The action plan sheet is still to be
created.
 
S

Simon Lloyd

That will be very easy to do and would be simple for you to understan
the action that is going on, you need to create your action plan shee
to know where to put the information copied, however it can be copied a
a whole row to the next available row in the action plan sheet

If you wish you can join our forum where you will be able to attac
your workbook and have someone help directly with that, it would be bes
when joining if you post in this thread http://tinyurl.com/999y4w as i
is this one and all the folk here who have been following it may benefi
or said:
I'm really not an expert user but here is the basic info

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

If the cell for M&E job is marked 'Yes' then I want the whole entr
(line
to be copied to the action plan sheet. The M&E heading is in cell D
and th
yes/no entry will be in cells D9:D67. The action plan sheet is still t
b
created




Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1
(http://www.thecodecage.com/forumz/showthread.php?t=43312
Click to expand...

--
Simon Lloy

Regards
Simon Lloy
'The Code Cage' (http://www.thecodecage.com
 
Top