Jump to content
Business Intelligence & Analytics for Digital Transformation

Kashmira

Members
  • Content Count

    22
  • Joined

  • Last visited

  • Days Won

    1

Everything posted by Kashmira

  1. 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
  2. Done filling names in highlighted cell. It was interesting.
  3. Excited to learn more and implement in my work. You are teaching it very well.
  4. 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
  5. This is excellent tool for files in one folder. 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
  6. hello, I was practicing scenario one - where change cell is unit price. Had a question. If I change the value in one of the unit price, doesnt it change the summary table by itself?
  7. Thanks. Inused this and it worked very welll. Thanks Kashmira
  8. 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
  9. 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
  10. 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
  11. Hi What function to use if I dont want every first letter of the word to be upper case. If it is paragraph want only first word , first letter to be upper case. Thanks Kashmira
  12. I just started learning from your tutorial and you really explain it very patiently. Learning a lot. Since I am not familiar with pivot table, I found this turotial little difficult to understand. I had to see it 2 to 3 times to understand it.
×
×
  • Create New...