By nateamack@mnipn.com on Thursday, 03 May 2018
Posted in Kutools for Excel
Replies 1
Likes 0
Views 5.8K
Votes 0
attached is a sample of the data I need to combine from multiple worksheets based on common data.... (can I do this with either the Kutools or Enterprise version?)

I have one worksheet for each month... (April 2017 is attached for reference)

I need to combine the information in the Premium Column A from each month/worksheet based on the common Branch Name in Column C. Each branch may or may not have data to combine from each month.

So hopefully it would look like this...
Premium CommDue Branch Carrier Date
$2,373.97 $356.11 Aitchison AAA Apr-17
$1234.00 $1.00 Aitchison AAA Mar-17
$1234.00 $1.00 Aitchison AAA Feb-17
$1234.00 $1.00 Aitchison AAA Jan-17
$1111.00 $1.00 Aitchison Allied Apr-17
$1111.00 $1.00 Aitchison Allied Mar-17
$1111.00 $1.00 Aitchison Allied

Kutools Help Screen Shot.JPG
Feb-17

I hope this can be done! Thanks for any help or ideas
·
5 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post