Macros within excel (v11.1.1 for Mac)

Topic

New Reply

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

Reply | Quote

Replies

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

Reply | Quote

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

Reply | Quote

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

Reply | Quote

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

Reply | Quote

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)

Reply | Quote

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

Mike

Reply | Quote

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

Thanks again

Reply | Quote