# Posts by ksstormhunter

Re: Evaluation Several Conditions

Hello, I have added the Headers to the Columns, is that what you needed.

## Files

Re: Evaluation Several Conditions

Here is the sample book with correct columns. The yellow area are what it should have returned correctly.

## Files

Re: Evaluation Several Conditions

Thanks for the solution, I have attached the results, it seems it is not catching the value of "-RA" several of the rows just say false instead of "-RA"

## Files

I have an Excel sheet trying to build a formula for the following. If s2>.01 then if x2="LIQUID" then if u2>=.01<=.1, "-TSRA", if u2>.1<.3,"TSRA", if u2>.3,"+TSRA", else if s2>=.01<.1,"-RA",s2>.1<=.3,"RA",s2>.3,"+RA", if x2="FROZEN" then if u2>=.01<=.1, "-TSSN", if u2>.1<.3,"TSSN", if u2>.3,"+TSSN", else if s2>=.01<.1,"-SN",s2>.1<=.3,"SN",s2>.3,"+SN", if x2="FREEZING" then if u2>=.01<=.1, "-TSFZRA", if u2>.1<.3,"TSFZRA", if u2>.3,"+TSFZRA", else if s2>=.01<.1,"-FZRA",s2>.1<=.3,"FZRA",s2>.3,"+FZRA", else if s2<.01, then ""

Re: Copy Data in a selected range based on criteria

On the first Sub routine it is pasting the data that is on sheet6 onto sheet 6, instead of taking the data from sheet 4 where my data is currently on.

Re: Copy Data in a selected range based on criteria

On the SelectRg.Copy Destination:=DestRg line i am getting Ojbect variable or With Block variable not set error.

Re: Copy Data in a selected range based on criteria

So basically I need to search in Column AA for the word "Passed", if yes then take that data on that fow from Column C to Z and paste into Sheet 6 Cell F5, then perform the same check on the next row down and so forth.

Re: Copy Data in a selected range based on criteria

No there are no headers for the data

Re: Copy Data in a selected range based on criteria

The data will go into Sheet6 Cell F5

I have a range of data from C10:AA120 and I need to only copy over only the rows of data that have in Column AA the word "Passed"

I have a value located in sheet5.range("b18"), which is a four letter text, such as KHDC

I need to search sheet22 in Row 1 through all the columns until it finds KHDC, There is other data located within each row 1 and column. An example is Station ID: KHDC Lat: When the value is found copy that column starting at row 1 to 150 and paste into sheet 7 range "a45".

The value in B18 will not always be KHDC, but can change based on user input.

Hello, have a little problem that I am trying to solve. I have a list of numbers in sheet dcount from a60 to a123 i am trying to find the minimum value in that list, but the problem is that some negative numbers contain the letter M for negative Example (-5, is m5) how can I determine the min value with those negative value in my range.

Okay, I do not know if this can be done, but really need some good guidance on this one. So here goes

I have an excel web query that get some weather data. the address does not change so it always updates that data. But I need to use some data from another site. That requires you to select the fields . So the address is not always the same. Is there a way to overcome this. would i have to maybe edit the address to display the info i want. or someone suggest a dynamic web query I have no clue how to go about doing this. Any help would be greatly appreciated

Here is the web address I am trying to acces. Any guidance would be appreciated