Automatic If statement / macro to copy one cell to different worksheet and print!

M

MikeD-Moyer

I'm new to this but please help.
I'm looking for an If statement to the effect of:

When column E="Un-Licenced" ( from drop down menu ), Copy Cell A in th
same row ( Contractor name ) to Sheet "First Notice" Cell D10. The
automatically print and clear pasted text.


I would like to be able to choice Un-licenced and it copies, pastes
prints and clears by itself.


Thank you, -Mik
 
M

MikeD-Moyer

jack_n_bub;1607014 said:
Hi,
Can you post a sample copy please. You may delete any data and put som
random figures. It would be useful to send me the same template you ar
originally going to use as if I happen to write the VBA code for you
you only would require to change the data not copy paste any code.

Prashant
Click to expand...

Heres a Dummy coppy.
Sorry I'm a few days late. Thank you for you're help

+-------------------------------------------------------------------
|Filename: Template.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=660
+-------------------------------------------------------------------
 
M

MikeD-Moyer

MikeD-Moyer;1607066 said:
Heres a Dummy coppy.
Sorry I'm a few days late. Thank you for you're help.
Click to expand...


Bump :).

Sorry everyone, I'm just hoping to get this help soon.


Thank you - Mik

+-------------------------------------------------------------------
+-------------------------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

After Macro runs, no cell activated - what am I missing? 2
Create if partial match then copy and paste data from one cell to another 1
How to do an IF statement that copy data based on a partial match 0
Print specific cells to another worksheet if check box cell links 0
Simple Copy to and From Cells With IF statement. 3
Copy cell value from one worksheet to matching worksheet in another workbook 4
Macro to copy a Cell Content automatically IF G12 cell <>"" 6
Print macro to exclude a cell 5

Top