columns in selection

I have columns for Ethnicity in this student data but the values are split across five columns (see attached). I need to fill in the Purple column (Column N) with a single Ethnicity value. So Row 2 would be "White", Row 12 would be "Black". I have been trying for 30 minutes and I just can't find...

Hey, I'm currently struggling trying to get this code working so I was hoping for a helping hand please? 　 the situation is: I have varying products that produce the owner's name as the outcome depending on circumstance. Initially I had it working fine from reading one column of info, but hit a...

Hi If I have a worksheet with three columns A, B and C. I can write a macro Columns ("B":"C").Select Selection.EntireColumn.Hidden = True If I insert new column B the data in B and C moves to C&D if you know what I mean How do I get my macro to hide the new C&D? I have tried defining the...

Hello everyone, I'm new to this site and I hope I get to learn VB more. I am developing a template for employee assessments. I've got the macro running to create blank assessment forms with column AI containing the employee's grade. There is no specific number of employees - as new employees get...

Hello, I'm working on a program recently to automatic generate graph based on a set of data. However, I am facing some issues now as I need to select Column A and Column C to setSourceData for my graph as shown below View image: table 1 I'm using CurrentRegion property to select the a table...

I'm working on creating a 'smart database' i Excel. Let's view my sheets: 1. 'Main' sheet where Mr Planner does his planning, using data from the two following sheets: 2. 'Clients' sheet. Rows contain Customer ID's. Columns contain all articles from next sheet. 3. 'Articles' sheet. Every...