Search results for query: *

That is exactly what I needed. Thank you very much.

I have been reading the posts in the thread, but my second posting today with corrected code crossed your very swift response to my first posting. However, I have now decided to use the forum707: VBA Visual Basic for Applications (Microsoft) instead, as per your reply to my orginal query...

Hi I have a spreadsheet with individual headings, and cell data in those columns that can either be 1, 2 or 3. I need to add a column that, for example, looks at each cell in row 2 and concatenates the column heading for each cell which has a value of 2. This would then give me a list in the...

Sorry, I pasted in the wrong code. The correct one is: Function concatenaterangemedium(Parts As Range, Separator As String) Dim strTemp, sepTemp As String Dim cel As Range Dim toprow As Range Dim cnt As Integer strTemp = "" For Each cel In Parts.Cells If...

Hi there, The code I have found is: Function concatenaterangemedium(Subject, Notes As Range) As String Dim strTemp, sepTemp As String Dim cel As Range Dim toprow As Range Dim cnt As Integer strTemp = "" For Each cel In Parts.Cells If cel.Value = "" Or cel.Value...

Sorry for the delay in replying to all your posts. It's been slightly manic at work. I'm not sure that I understand the using of pivot tables, so I think it would probably be beyond my colleague as well. What I did discover on the internet was code which concatenates ranges. However, I...

The problem is my colleague doesn't want the table in a database, she wants it in excel, as she finds excel easier to use. So I'm having to try to make it work somehow. What she wants is a spreadsheet with column 1 with names, columns showing total rankings and course names for those rankings...

It is for work, each column being modules or courses. What I need to do is enter a ranking of 1, 2 or 3 against any module or course any staff member has done. Some cells will be filled in, others will be blank. What I then need is a list of the name of each module or course each member of...

I have a spreadsheet with over 500 columns with individual headings, and cell data in those columns that can either be 1,2 or 3. I need to add a column that, for example, looks at each cell in row 2 and concatenates the column heading for each cell which has a value of 1. This would then give...