tutorials

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...

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 =...

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...

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

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...

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...

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...