Activate another sheet based on value in a cell
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Activate another sheet based on value in a cell

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    85
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have 2 workbooks. Workbook1 and Workbook2. Workbook1 contains 1 sheet. Workbook2 contains 5 sheets. My data in Workbook1 is copied via a macro...I want to paste it to a particular sheet in Workbook2 bases on the value in cell A1 of Workbook1. for example... Workbook2 contains 5 sheets each named after different cities; New York, Miami, Cleveland, etc. When my macro copies the data from Workbook1, based on the city name in cell A1, I want it to paste it to the corresponding sheet in workbook2. Does this make since??? It's kind of hard to type it out. Any suggestions would be appreciated...

    [ This Message was edited by: graphage on 2002-03-12 12:06 ]

  2. #2
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Try turning on your macro recorder.
    See what code you get.

    Then post what you have and what you
    need to change.....Always a good idea to
    use the macro recorder then alter code to suit.....

    Post for further assistance.


    Cheers

    ivan

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com