1. D

    Where to acquire advanced - really advanced excel skills

    So I was introduced to excel 3 years ago. (I'm 18 btw). I just learned the sum function and was sooo amazed, and I built a complex "model" for my schools student grant allotment [i did it for fun, and they accepted it :), i caught on pretty quickly.. etc...] Then I watched excelisfun on...
  2. M

    Using Left in VBA

    Hi, I'd like to change the following code such that only the Left three characters of the Department value are taken. Left tutorials aren't helping me much. With ws .Cells(ERow, 1).Value = Me.ptmember.Value .Cells(ERow, 2).Value = Me.StudyRole.Value .Cells(ERow, 4).Value =...
  3. S

    How To Move Entire Row To Various Sheet Based On Cell Value In Excel?

    Hello everyone, all the tutorials I've search has the same result. Most tutorials shows you how to copy the Row from Sheet 1 to Sheet 2 only. Maybe I am not searching it properly? What I need is to COPY Row from Sheet 1 to Sheet 2 OR Sheet 3 OR Sheet 4 depending on the value on Column "M" Can...
  4. H

    Excel Power Query Tutorials

    I am new to Power Query and would appreciate it, if someone could recomend a few online tutorials as well as online training on this topic
  5. N

    Good idea? Maybe?

    Hello All, So I joined this forum back in 2016 and since then have learned SO MUCH INFORMATION that has helped me and now I am able to help others that were lie me before i joined here. It has been an awesome ride and I really enjoy it. With that being said I have been thinking about making a...
  6. S

    Macro beginner questions

    Hi, Over the last week I've been teaching myself to develop very simple macros with goals of becoming a master one day. My questions in red are: 1. can anyone recommend beginner tutorial sites similar to this one that I've been using https://www.homeandlearn.org/index.html? 2. Ultimately, I...
  7. C

    Userform from existing database

    Hi all I have an existing excel database which i'd like to 'maintain' with the help of a purpose made Userform. It contains 64 columns of fields (one of which being the record name), with a different row for each record. The database already consists of mainly drop down boxes, with a few free...

Some videos you may like

This Week's Hot Topics