[mso] Excel VBA Code

Hi All,

I feel I am about to conquer Everest here, but for all you vba gurus,
let's not laugh now. I am teaching myself vba, and applying it to some
stuff I am working on, and was wondering if some kind soul out there
could help me with a code to carry out a certain function, as part of a
bigger code. It needs to perform the following task:

1)On sheet 2 (which will be the active sheet); look at cell D6 and if it
says "Non Specified", ignore this cell and move on to cell D7. If there
is any other value in this cell, copy that value to cell B2 on sheet 1

2) Look at cell D7 (sheet 2) and if it says "Non Specified", ignore this
cell and move on to cell D8. If there is any other value in this cell,
copy that value to cell c2 on sheet 1.

The idea is to repeat the above from d6 to d15 on sheet 2 (vertical),
and copying the contents (if something has been specified)from b2 to j2
on to sheet 1(horizontal.

I am looking for a vba code solution and not a formula, as I would b2 to
j2 on sheet one not to contain formulas (there is a method in the
madness, trust me).

I hope I have explained myself ok, but if not, please give me a shout
guys.....


Many thanks

Herbert
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to share files with the group, you must join our Yahoo sister group. 
 This group will not allow for posting of emails, but will allow you to join 
and share problem files, templates, etc.:  
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE 
SHARING ONLY.

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: