Hello,

I'm back (again). This may be challenging. I have a worksheet with a table (dates on one axis, products on another). On the last worksheet I have a command button. What I want the button to do is populate a new Excel sheet (in a new window) with all of the products – but with 6 months’ worth of data.

So, currently, the table looks like this (for example):

January 1 January 2 January 3 January 4
Product 1

Product 2

Product 3

Product 4

I want the command button to populate a new Excel with a list of the products (Product, 1, Product 2, etc.) but with the next columb of cells having 6 months’ worth of data – which means it will have to add up the columns with the dates (the dates are by day, so it’ll have to add up quite a few columns).

Is this even possible? I have the simple macro below, but it just populates a new excel without any of the data in it.

Sub Newbook12()
MyBook = ActiveWorkbook.Name
Workbooks.Add
ThatBook = ActiveWorkbook.Name
Workbooks(MyBook).Activate
End Sub