Kashmira

Hi

I could do the assignment for this tutorial. Converting celsius to Fahrenheit.

I tried to add With Range and it gives me error, object require. Pls advise where my code is wrong.

Sub celcius()

Dim celcius As Integer
Dim Farenhiet As Integer

celcius = InputBox("Give me temperature in Celcius")

Range("B3").Value = celcius

Farenhiet = (celcius * 1.8) + 32

    With Range("B4").Value = Farenhiet

                .Font.Size = 11

                .Font.Color = "2367"
    
MsgBox "Farenhiet is" & " " & Farenhiet

End With

End Sub

Without using "With" it works. Do I need to use the Worksheets object. ?

How can we do combining data from different worksheet in new worksheet within one file ?

Is it possible.?

I have attached the file. 

I want only coloured cells from worksheet - call , miss into follow up worksheet. 

combining data from differennt worksheet.xlsx

Thanks. Inused this and it worked very welll.

Thanks

Kashmira

Hello thanks for the idea. i tried this. Extracted postal code with mid( ). When i use vlookup giving reference to this extracted postal code, it gives me error. I cooy postal code and paste as value. Still it gives me  an error. Its only when i type the postal code, vlookup gives me data.

Is there any way around to overcome this problem.

Thanks

Kashmirs

Hi

By using Concatenate - we are able to put all the text of different cell in one cell. But it comes up besides each other. I separate it with comma. But I want text of all cell in one cell one below other. Is it possible. 

Eg. Concatenate - gives  -120 hill ave, york on ca, l5b 

I want - 120 hill ave

              york on ca

              l5b

Thanks. Will try that.

Hi 

Can XLOOKUP / VLOOKUP be useful for the text in the cell. 

I have a city and postal code in B1 cell. And based on postal code in B1 cell, I want return - package center name .

I have table for postal code and center name associated with that postal code.  I tried using vlookup and xlookup, but I am not getting the result.

Attached is the file. 

Thanks

Kashmira

XLOOKUP.xlsx