Ikaabod, WB2 is a workbook that has projects listed in Column A. The
project identifier is actually the left(6) characters. WBwip is a pivot
table that has those same projects listed with total expenditure amount
listed in Column (J). What I want is to match the project in WB2 with
WBwip in Column A, then offset that found cell to Column (J), the
expenditure column and display the detail of that expenditure, which
actually adds a sheet to WBwip. Then move that detail sheet to WB2. As
an example WB2 identifies A7=06-013, the result 06-013 is used to
lookup the project in WBwip. Once it finds the matching 06-013, it
offsets to the total expenditure column and displays the detailed
results of that expenditure and moves that detail sheet to WB2. Once it
does that, it loops through the rest of projects in WB2 and does that
until all projects have been added to WB2. The finished result is WB2
has the initial project sheet with additional detailed expenditure
sheets for each project.

When I did with it with the input box, everything worked perfectly, but
if I had 10 projects I had to run the macro 10 times. I just want to
eliminate the input box and loop through the projects to achieve the
same results. HTH

Greg