0
Undo
Votes
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
Feb-17
I hope this can be done! Thanks for any help or ideas
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
Feb-17
I hope this can be done! Thanks for any help or ideas
- Page :
- 1
There are no replies made for this post yet.