Create side by side report from single list non vba with criteria

jimrward

Well-known Member
Joined
Feb 24, 2003
Messages
1,739
Office Version
2016, 2013, 2011, 2010, 2007
Platform
Windows
Looking for a method to produce side by side list either double triple or quad

I have a csv list from an external source for example containing in date order

Date,type,item,count

To save paper either in portrait have two lists from source
Sourcerow1, sourcerow2
Sourcerow3, sourcerow4

And so on until list1 is exhausted

Now for the criteria I may want to match only on one particular item, held in another cell

In matching on that criteria there may be instances where there might be multiple rows for the same date for that item, in which case I would want to sum the count and post only a single row to my report

I may to do the sum of the count before processing to a new single list to simplify things
 

Some videos you may like

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

Watch MrExcel Video

Forum statistics

Threads
1,095,711
Messages
5,446,096
Members
405,379
Latest member
EDGOUG

This Week's Hot Topics

Top