Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Movng Data Automatically the Fits a provision
Sub versive()
Dim myRange As Range Set myRange = Range("D2:D25") For Each "c" c.Select If c.Value = 1 Then Selection.EntireRow.Copy Worksheets("Sheet2").Rows("1:1").Insert Shift:=xlDown End If Next End Sub The above formula was given to me by a "Mike" but I am uncertain how to use it. what I am trying to do is make excel pickout data that equals a certain text value and move it automatically to another worksheet in a workbook. If anyone can help me out here I would appreicate it. I am NOT allowed to use ACCESS I must use Excel. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I list all Data in a column that fits between two points? | Excel Discussion (Misc queries) | |||
I would like a function to return a value that fits its range | Excel Worksheet Functions | |||
automatically expand chart data series as data is added | Charts and Charting in Excel | |||
nonlinear regression/ curve fits | Excel Discussion (Misc queries) | |||
Making an alphabetical list that fits on one page. | New Users to Excel |