learner

Hello! I am updating a document for work and which shows projects being worked on and their status. I would like rows which have been marked as "Archive" to be automatically moved onto another worksheet so as not to clog up the current work. How do I input a code to enable that to work...

Hi folks, I can use some help on a macro. Data will be pasted into this file into A2:J, and I need a macro to: 1. Remove all rows where value in column H is 3 or higher. 2. Count or CountA column H for each unique 'Learner' name in column A. (do not subtotal attempts) 3. Output list of...

Hi! I have what I think should be very simple, but is not working for me right now! I am working on a scorecard sheet. So, we have a number of metrics, and for each we have Target and Goal for every month. Then, for each metric, there is a calculation of the percentage-where are they in...

Hi, I am new(ish) to pivot tables and looking for some help please: We have had a group of people assess how good they are at a number of activities by rating themselves Red, Amber or Green, and I now want to pull together a single table showing how many red, how many Amber and How many green...

Hi Guys I am sort of good at using excel for finance function for my job purpose. However I have come across some VBA enabled excel sheets which do excellent job. I would like to learn how to code VBA. I have started reading a book on VBA learning. It would be great if you can give me some...