Results 1 to 8 of 8
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Location
    Charlottetown, Prince Edward Island, Canada
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Macros within excel (v11.1.1 for Mac)

    I have three worksheets, each sheet has a common column that ties all 3 work sheets together (each sheet contains different informatin associate to that "key". I want to create a fourth worksheet that brings information together from the other three sheets. So i need to find the information using the "key" from all three sheets then when it finds a match, copy the required cells to their new cell location on worksheet four. Hope this makes sense (lookup and insert/copy i think). Anyway, if someone could prvide some guidnace on what the macro would look like or some ideas to make this work, i would appreciate it.

    thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Macros within excel (v11.1.1 for Mac)

    Could you attach a workbook that demonstrates what your data look like, with an example of what you want the end result to be?

  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Location
    Charlottetown, Prince Edward Island, Canada
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macros within excel (v11.1.1 for Mac)

    i can work up a rough example and send it along, the concept will be the same.

  4. #4
    Star Lounger
    Join Date
    Jan 2001
    Location
    Charlottetown, Prince Edward Island, Canada
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macros within excel (v11.1.1 for Mac)

    here is the basic idea, i have three worksheets and added on worksheet Mike the results and where they should come from. My problem originates from having multiple excel worksheets that are combined into one big excel then i have to summarize into one page using various cells from other worksheets. a bit over my level of understanding with macros.

    thanks for any help

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Macros within excel (v11.1.1 for Mac)

    In F7: L7 add the formulas (respectively):

    =IF($E7="","",VLOOKUP($E7,'sub schedule'!$E$7:$G$28,2,0))
    =IF($E7="","",VLOOKUP($E7,integration!$E$7:$J$28,2 ,0))
    =IF($E7="","",VLOOKUP($E7,integration!$E$7:$J$28,3 ,0))
    =IF($E7="","",VLOOKUP($E7,integration!$E$7:$J$28,4 ,0))
    =IF($E7="","",VLOOKUP($E7,integration!$E$7:$J$28,5 ,0))
    =IF($E7="","",VLOOKUP($E7,integration!$E$7:$J$28,6 ,0))
    =IF($E7="","",VLOOKUP($E7,'sub schedule'!$E$7:$G$28,3,0))

    Copy F7:L7 down the rows to fill in as far as desired.

    Steve

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Macros within excel (v11.1.1 for Mac)

    You don't need macros for that, VLOOKUP formulas will do. See attached version (there are many 0s now because the worksheets are mostly blank)

  7. #7
    Star Lounger
    Join Date
    Jan 2001
    Location
    Charlottetown, Prince Edward Island, Canada
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macros within excel (v11.1.1 for Mac)

    Thanks,,,,,,,i really appreciate your help!

    Mike

  8. #8
    Star Lounger
    Join Date
    Jan 2001
    Location
    Charlottetown, Prince Edward Island, Canada
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macros within excel (v11.1.1 for Mac)

    just applied this to my excel spreadsheet and it worked great!

    Thanks again

Posting Permissions

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