No problem. The macro is extremely long and exists on another network. I cannot paste the whole thing over. I can rewrite some of it, though.

What it does:

1) User copies a bunch of text to clipboard
2) User goes to Excel and runs macro
3) Macro pastes and does a bunch of nifty reformatting and such. One of the things it does is:

Column B now has a bunch of numbers in it; one in each cell. One step of the macro is to look at each of those numbers and determine whether they appear anywhere in a separate sheet, called "Comments." This is the sheet with over 150,000 rows. Every time it finds that number, it pastes the entire row(s) into a cell in Column A on the original sheet, just to the left of the corresponding number (which is stil in Column B).

For example, if Cell B5 has the number 93428, Cell A5 may look like:

My favorite number is 93428.
The number 93428 is how many jelly beans are in this jar.
George owes Donald $93428 dollars.

How it does this:

It does this by creating a custom function. That function is:

Public Function findseries(trange as range, matchwith as string)

For Each cell in trange
if cell.value like matchwith then
x = x & cell.offset(0, 0).value & "%"
end if
next cell
findseries = left(x, (len(x) - 1))

End Function
The line in the macro that uses this function is:

Range("A2").Select
ActiveCell.Formula = "=if(iserror(findseries(COMMENTS!A1:A250000,""*""&B2&""*"")),"""",findseries(COMMENTS!A1:A250000,""*""&B2&""*""))"
Range("A2").AutoFill Destination:=Range("a2:a" & Range("c" & Rows.Count).End(xlUp).Row)

As far as PowerPivot, I do not have access to it on the network that this spreadsheet is on. I can try to get the IT guys to add it if you think its the answer.