need to copy data from worksheet to month's worksheet - help
Eliminate Pivot Table Annoyances
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: need to copy data from worksheet to month's worksheet - help

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

    Default

     
    I have a data entry worksheet. I want to create a macro that will copy the data onto the appropriate month's worksheet. For example, if I enter on the data entry worksheet that this call came in on 01/02/02, then list the details of the call in the adjoining column, I want the entire row to copy onto the first empty row on the correseponding month's worksheet (January, in this case). I want the call report to remain on the data entry worksheet, but also to appear on the month's worksheet.

    Is this possible or do I have to copy and paste each time?

    Thanks for any help!
    Beth

  2. #2
    Board Regular
    Join Date
    Apr 2002
    Location
    St. Louis
    Posts
    71
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Beth,

    Have you tried the DATA-FORM command from the menubar?

    Dexter

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Posts
    166
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I don't see where that will put the information on both the data entry tab AND the correct month's tab. Am I missing something?
    Thanks for responding!
    Beth

  4. #4
    Board Regular
    Join Date
    Apr 2002
    Posts
    166
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    I'm hoping to copy the information by date onto the first empty row of its corresponding worksheet (in the same workbook). Any ideas?
    Thanks!
    Beth

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