|
Re: Lookup
Sorry...my bad. I'm using Excel 2007 and always have problems executing macros from downloaded websites. Do this...
1) Alt + F11 to open the VBA editor
2) Right click on the name of your file and select INSERT / MODULE
3) At the top of the module, enter (without quotes)
"Sub Summarize"
(you'll notice that you automatically get "End Sub" displayed a few lines down)
4) Paste the code I gave you between SUB SUMMARIZE and END SUB
...
Now, you can move your data so that it starts in cell A2
To run the code, click on the little green arrow button in the VBA editor window. Let's make sure it works before doing anything else...
__________________
Who believes in telekinesis... raise my hand!
|