consolidating multiple workshheets
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: consolidating multiple workshheets

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I need to add data from multiple worksheets into one large sheet on aregular basis. i have been copyiny data and pasting, I am trying to see if there is a way to automate this process by naming the sheets. thanks for any help.

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Stockton, California
    Posts
    281
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try recording a macro. Then you can use this macro to do the same thing in the future (assuming your future worksheets will be formatted the same)

  3. #3
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-28 17:14, deuxo wrote:
    I need to add data from multiple worksheets into one large sheet on aregular basis. i have been copyiny data and pasting, I am trying to see if there is a way to automate this process by naming the sheets. thanks for any help.
    Hi deuxo:
    In addition to robfo0's suggestion, you should also explore DATA|CONSOLIDATE featue built in Excel for a purpose like yours!

    _________________
    Yogi Anand

    Edit: Deleted inactive website from hardcoded signature

    [ This Message was edited by: Yogi Anand on 2003-01-19 14:20 ]

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Ahmedabad Gujarat
    Posts
    303
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yes there are lots of way to do that.

    First it depends how you are putting the logic..

    Well your question interest me..

    Can you explain me more in detail..or send workbook to me at

    nisht@pexcel.com

    please send me the zip file.

    May i can help you.

    ni****h desai

  5. #5
    New Member
    Join Date
    Mar 2002
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for responses. To clarify what I m trying to do,I have multiple sheets of data in the exact same format. I want to append the set of data from each sheet to the end of a data list in one large sheet. I do not want to add cells together, as you do under DATA>consolidate. I have been copying and pasting, which works fine but is taking to much time as I add more worksheets. I am trying to see if there is a way to do without a macro, or if someone has a macro I could look at. thanks,

  6. #6
    New Member
    Join Date
    Mar 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    I have similar problems
    anyone got a macro code on this.. Thanks

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