hello ALL :D,

i have this problem that i cannot find the solution. i want to extract only selected cells but right now i extract all the unwanted cells. is there a program or functions that i can extract a range of data? please help me.

thanks and regards,
rachel

You will need to clarify your request a bit... What exactly do you mean by "extract"?

i want to extract only particular cells. now i extract out some of the unwanted cells. what i mean by "extract" is by selecting and copying only the selection that i want, without copying the unwanted cells.

Rachel:
You will have to help me.
Which cells are you extracting from? (e.g. is it a whole column or a particular range)?
What condition are you using to select (or reject) cells? (e.g. is zero; or is > 25)?
Are you doing this directly within Excel or are you using VBA?

Can you describe what you intend to happen and the environment within which it happens?

From what you have written so far it looks as though you might be wanting to scan a group (range) of cells and, if the content of the cell satisfies a particular condition, copy its contents to another cell; otherwise ignore it. Is that the scenario?

Alf

Which cells are you extracting from? (e.g. is it a whole column or a particular range)?
-particular range from a given condition.

What condition are you using to select (or reject) cells? (e.g. is zero; or is > 25)?
-select cells according to the dates given.

Are you doing this directly within Excel or are you using VBA?
-im using VBA.

Can you describe what you intend to happen and the environment within which it happens?
-the first thing to do is to refer to the given date from a cell. then from the given date, i need to find the match from a given row list dates. when the match is found, then the next step is to find the column list dates. when both are found and matched to the given date, then i need to copied the data within that two dates found and paste it into a new cell.

From what you have written so far it looks as though you might be wanting to scan a group (range) of cells and, if the content of the cell satisfies a particular condition, copy its contents to another cell; otherwise ignore it. Is that the scenario?
-yes you are right.

actually i have already done the program. it works correctly to what i want but the thing is that it extract the data together with the unwanted cells data. i only want the program to copy the exact data cells. so at this stage, i need your help to edit my program i presume. it would be better if i can send you a copy of my file so that you can have a better understanding to what i actually post. is there any way that i can attached you my file?

these are my codes:
Sub get_data8()

      Dim dteDateIn As Date

     dteDateIn = Range("A32").Value
     Range("G4").Select
     Range(Selection, Selection.End(xlToRight)).Select

     For Each testcell In Selection
     If dteDateIn = testcell.Value Then
       NextFourForward = Range(Cells(4, testcell.Column + 0), Cells(4, testcell.Column + 3)).Select
       Range(Selection, Selection.End(xlDown)).Select
       Selection.Copy
       Range("B33").Select
       ActiveSheet.Paste
     Exit For
     End If

    Next testcell

     Range("E5").Select
     Range(Selection, Selection.End(xlDown)).Select

     For Each testcell In Selection
     If dteDateIn = testcell.Value Then
       NextFourUpward = Range(Cells(testcell.Row - 0, 5), Cells(testcell.Row - 3, 5)).Select
       Range(Selection, Selection.End(xlToRight)).Select
       Selection.Copy
       Range("a34").Select
       ActiveSheet.Paste
     Exit For
     End If

    Next testcell
    Cells(33, 1).Select

End Sub