art

I am trying to add text using the concatenate function....for example=concatenate(a2,b2,c2) which works fine however if I try this =concatenate(a2:c2) comes back with a hashVALUE error....but...... What I am trying to achieve is to extract data from a report which gives me the subject the...

Is it possible to highlight cells based on another cell. That is a bit of an oversimplification. My table looks something like this: <tbody> Choice 1 Choice 2 Choice 3 Choice 4 Choice 5 Choice 6 Option W Option X Option Y Option Z History Spanish Media RS PE Art History Spanish Art RS...

Hi Any ideas how I can get the second most commonly occurring text value based on an if. The data I have is as follows: <tbody> A B C Class Teacher Subject 10x/Ar1 AOW Art 11x/Ar1 AOW Art 11z/Ar1 AOW Art 7L10/Ar AOW Art 7L3/Ar EBE Art 7L8/Ar EBE Art 10y/Ci1 RAM Citizenship...

I know I have asked this question previously and I really can't figure out a way to do this so thought I would try this amazing forum again :) I need to populate the table below: <tbody> Last Name First Name Reg Group Art Group Art Teacher Art Target Art EFG Art EFG-FFT Art Effort Art...

As the title says really. I have a table which looks something like: <tbody> Ethnicity English Maths Science Triple Science Art Drama Citizenship Geography 1 Black Caribbean Y Y Y Y Y 2 Afghan Y Y Y Y Y 3 Afghan Y Y Y Y Y 4 Indian Y Y Y Y Y Y Y </tbody> So I want a unique...

Hi, I am looking for a solution for the following. In the column on the left I have different article numbers, each article number has one or more (up to 20) Sales Orders attached to it. For each article number, I would like to see the sum of all Sales Orders attached to that specific article...

Using VBA, is it possible to change the RGB color (say green) of a selected element within a smart art object (say Org chart). I know that we can do it if we know the element number - how about an element selected at random? Please advise as soon as possible.

I know how to clear data validation in a range of cells or change the list reference But I have over 600 cells that need changing so even copying is a bit arduous What I would like to do is replace my list =listname with a different =differentlistname so I don't have to go into 20...

Hello all! I am wanting to take information and put it in a separate worksheet if all the information is the same in column C, F, and G If so, I would like to pull the Low Year (Column A) and High Year (Column B) So basically want to say from 2002 - 2005/ ART 101/ INTRODUCTION TO ART/3 CREDITS...

Sub ArtReport() With Sheets("art report") .Unprotect lRow = Worksheets("art report").Cells(Worksheets("Invoice").Rows.Count, 1).End(xlUp).Row lRow = lRow + 1 'Inv no Sheets("Invoice").Range("I8").Copy Worksheets("art report").Range("A" & lRow).PasteSpecial xlPasteValuesAndNumberFormats 'date...

Hello All, I'm new here, so please forgive my naivety. I've watched dozens of videos in an effort to resolve my issue, with no luck. So, I'm reaching out to the experts. Issue: I work for a printing company. We want to group art across the paper based on label quantities in the most efficient...

Hello forums, I have a dream of an Excel macro or tool that would make my job infinitely easier, but attempting to cobble it together on my own from Google and forum posts has not proved fruitful. One of my job duties is to take reports that are exported nightly and compare them to determine...