Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I am looking for help on a formula
Ok, I usually can get around problems with formulas, but this one is
beating ym brain to a pulp. Anyone knows how to make the following happen? Using sheet1, I want to transfer the entire line of text to another sheet, using my customer names. That way, I can keep track of who ordered what and when, and how much was paid for it, instead of jumbling it on one sheet. The process would have me creat about 15 different sheet to track my customer's activities. Than you |
#2
|
|||
|
|||
Keep it on one sheet, and use data filters to show just the customer that
you are interested in. Much better technique, less prone to errors. If you must have separate sheets, try the macro below. HTH, Bernie MS Excel MVP Sub ExportDatabaseToSeparateSheets() 'Export is based on the value in the desired column Dim myCell As Range Dim mySht As Worksheet Dim myName As String Dim myArea As Range Dim myShtName As String Dim KeyCol As Integer myShtName = ActiveSheet.Name KeyCol = InputBox("What column # within database to use as key?") Set myArea = ActiveCell.CurrentRegion.Columns(KeyCol).Offset(1, 0).Cells Set myArea = myArea.Resize(myArea.Rows.Count - 1, 1) For Each myCell In myArea On Error GoTo NoSheet myName = Worksheets(myCell.Value).Name GoTo SheetExists: NoSheet: Set mySht = Worksheets.Add(befo=Worksheets(1)) mySht.Name = myCell.Value With myCell.CurrentRegion .AutoFilter Field:=KeyCol, Criteria1:=myCell.Value .SpecialCells(xlCellTypeVisible).Copy _ mySht.Range("A1") mySht.Cells.EntireColumn.AutoFit .AutoFilter End With Resume SheetExists: Next myCell End Sub "voyager via OfficeKB.com" wrote in message ... Ok, I usually can get around problems with formulas, but this one is beating ym brain to a pulp. Anyone knows how to make the following happen? Using sheet1, I want to transfer the entire line of text to another sheet, using my customer names. That way, I can keep track of who ordered what and when, and how much was paid for it, instead of jumbling it on one sheet. The process would have me creat about 15 different sheet to track my customer's activities. Than you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |