Changing Parent levels to Base Member units in BPC

Hi,

I am trying to change the Parent levels in OutlookSoft BPC to be replaced by all of the Parents' base members within our spreadsheets so that we will only be looking at base level members within the spreadsheet. I can use the members.xls to create a vlookup table to show the base members' parents, but I can't to the reverse. The spreadsheet has over 6,500 entries, so a manual copy/paste with the BPC dimension search feature is out of the picture. Is there any way to change all parents to base level units a la Find/Replace with multiple Base Members?

I'm using OutlookSoft BPC 4.2.