PC Review


Reply
Thread Tools Rate Thread

Copy content of cell to another depending on value of third cell(between worksheets)

 
 
Zeljko Milak
Guest
Posts: n/a
 
      14th Jul 2006
I have just begin to learn VBA for Excel and I need help.
Can anyone give me code that copy content of cell in one worksheet to
cell in other worksheet dependending of value in third cell. For example
how to copy content of desired range of cells at sheet2 to some range in
sheet3 depending of value of cell in sheet1 which is date.

Thanks.
 
Reply With Quote
 
 
 
 
tony h
Guest
Posts: n/a
 
      14th Jul 2006

Most people who are learning VBA with no previous experience start by
using the "record Macro" feature under the Tools..macros menu.

Then look up the "if" statement

give it a try and if you get stuck post again.

hope this helps.


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=561427

 
Reply With Quote
 
Milax
Guest
Posts: n/a
 
      14th Jul 2006
tony h wrote:
> Most people who are learning VBA with no previous experience start by
> using the "record Macro" feature under the Tools..macros menu.
>
> Then look up the "if" statement
>
> give it a try and if you get stuck post again.
>
> hope this helps.
>
>

Thanks!
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I copy a row depending on the content of a cell in the row =?Utf-8?B?Um9iZXJ0NTk=?= Microsoft Excel Worksheet Functions 2 19th Oct 2007 06:26 PM
Sum data, depending on cell content Mik Microsoft Excel Worksheet Functions 6 18th Oct 2007 04:30 PM
Set Row Height depending on cell content... =?Utf-8?B?VHJldm9yIFdpbGxpYW1z?= Microsoft Excel Programming 7 13th Aug 2007 03:02 PM
Automated cell copy depending on cell content? Joachim Fabini Microsoft Excel Programming 5 20th Nov 2003 07:54 AM
autowrite a cell depending on another cell's content jose carreno Microsoft Excel Programming 2 1st Oct 2003 05:50 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:01 AM.