# Thread: Macros within excel (v11.1.1 for Mac)

1. ## 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. ## 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. ## 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. ## 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. ## 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. ## 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. ## Re: Macros within excel (v11.1.1 for Mac)

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

Mike

8. ## 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
•