#range

Hello, I'm a newbie to type VBA code. Recently, I would like to create a series of VBA code in order to accelerate work. Now, I have faced the problems below: 1. I would like to count the number of "LTG" which has 3 merged rows only.(shown in the uploaded image) 2. About the Find Function, I...

Hello guys, I was wondering if someone could help me. I have a range from H5:H12 from wich I need the average but I cannot include the cell H11. Because I'm in an Excel Course, the professor asked specifically for the function AVERAGEIF but many classmates and myself included, can't find the...

Hi Everyone, New to the forum and really appreciate anyone who can assist. Below is a simple version of a much more complex data set that I am working on. I am trying to get excel to identify numbers within a contiguous number range in a single cell and place an "X" in the corresponding...

hi all, I have an excel workbook in which I want to automatically update selection lists based on the user who is logging in and which selection is made from a few dropdown boxes. The user does the following steps: 1. Login (the username is saved to named range called cCurrent_User in the...

Hi everyone. I have a simple query. Is there a simple way of copying the data of a named range into another worksheet? Thanks in advance.

Hi, I wonder if anybody could help with this one: You have a table with invoice numbers and amounts by vendor. The job is to add a "User" column into this table using vlookup and/or other excel functions showing User1/User2/User3 linked to each vendor name, when you have a reference table on a...