Skip to main content
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Thursday, 03 May 2018
  1 Replies
  5.6K Visits
0
Votes
Undo
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
·
#1557
0
Votes
Undo
  • Page :
  • 1
There are no replies made for this post yet.