wrapiop.blogg.se - Create new tab in total commander

#Create new tab in total commander password

SheetName = RTrim(Left(FilterRange.Value, 31)) WsFilter.Range("B2").Value = FilterRange.Value WsFilter.Range("B1").Value = wsFilter.Range("A1").Valueįor Each FilterRange In wsFilter.Range("A2:A" & rowcount) Rowcount = wsFilter.Cells(, "A").End(xlUp).Row

Columns.Count).End(xlToLeft).ColumnĮrr.Raise 65000, "", "FilterCol Setting Is Outside Data Range.", "", 0 Cells(.Rows.Count, FilterCol).End(xlUp).RowĬolcount =.

#Create new tab in total commander password

Unprotect Password:="" 'add password if needed Set objRange = Application.InputBox("Select Field Name To Filter", "Range Input",, ,, ,, 8)

Thanks for any help - I have little experience with coding or vba, so anything is much appreciated.ĭim ws1Master As Worksheet, wsNew As Worksheet, wsFilter As Worksheetĭim Datarng As Range, FilterRange As Range, objRange As Rangeĭim colcount As Integer, FilterCol As Integer, FilterRow As Long The sheet would be continually updated, so it would make sense if each time the macro was run, the information was wiped and recreated.

Create a linked (to each tab) summary tab of the totals, by month, for each product.

Create a linked (to each tab) summary tab of the totals, by month, for each customer.

Copy and paste the headers and all of the information for that customer (columns A through N) to the new tab.

Create tabs for each unique customer value.

I would like to be able to run a macro to help out with the following: rows) will be volatile, but the number of months (ie. The number of customers and products (ie. I have a worksheet with headings in row 7, a list of customers in column A, lists of products each customer sells in column B, and monthly sales information from columns C to N. but maybe people can just chime in on pieces and we can build from there?