Closed Thread
Results 1 to 3 of 3

Find maximum values from multiple imported sheets into a summary sheet.

  1. 12-04-2012, 09:01 PM #1
    rageshprasad is offline
    Registered User
    Join Date
    11-16-2012
    Location
    Santa Barbara
    MS-Off Ver
    Excel 2010
    Posts
    29

    Find maximum values from multiple imported sheets into a summary sheet.

    Hello All,

    I have multiple csv files that i have imported into Excel. The first sheet is a summary sheet. and the others are sample 1, sample 2 etc, depending on the number of file import. This importing potion of the code works fine.
    I need help with find first checking hoe many sheets are imported and from each worksheet (only from column C) get the maximum in the summary sheet. so if 10 files are imported then i get 10 differnt max values.
    Please, anyone who is will to help, i can upload my files for you to see what i have done so far.

    Thanking you all in advance.

    Ragesh
    Reply With QuoteRegister To Reply
  2. 12-05-2012, 01:15 AM #2
    dilipandey is offline
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Find maximum values from multiple imported sheets into a summary sheet.

    Hi Ragesh,


    Please upload the sample workbook. thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
    Reply With QuoteRegister To Reply
  3. 12-21-2012, 01:31 AM #3
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Find maximum values from multiple imported sheets into a summary sheet.

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]
    Reply With QuoteRegister To Reply
Closed Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1