Jump to content
One on One Extensive Advanced Excel Training ×
Business Intelligence & Analytics for Digital Transformation
One on One Extensive Advanced Excel Training

Kashmira

Members
 View Profile  See their activity

  • Posts

    22

  • Joined

  • Last visited

  • Days Won

    1

 Content Type 

Everything posted by Kashmira

  1. Kashmira
    program done. It was nice.
  2. Kashmira
    seen entire video.
  3. 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. ?
  4. Kashmira
    Done finding Perimeter and radius
  5. Kashmira
    fantastic. looking forward to learn more.
  6. Kashmira
    Done filling names in highlighted cell. It was interesting.
  7. Kashmira
    The output cell is I10
  8. Kashmira
    Done my assignment.
  9. Kashmira
  10. Kashmira
    Excited to learn more and implement in my work. You are teaching it very well.
  11. Kashmira
    labtop.color="silver" labtop.processor="ryzen"
  12. Kashmira
    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
  13. Kashmira
    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
  14. Kashmira
    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?
  15. Kashmira
    Thanks. Inused this and it worked very welll. Thanks Kashmira
  16. 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
  17. Kashmira
    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
  18. Kashmira
    Thanks. Will try that.
  19. Kashmira
    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
  20. Kashmira
    Is TEXTJOIN feature is only in 2010 excel ?
  21. Kashmira
    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
  22. Kashmira
    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...