row header

Hi All, I am currently using this code provided by @John_w in this thread. Public Sub Copy_Values_From_Workbooks() Dim matchWorkbooks As String Dim destSheet As Worksheet, r As Long Dim folderPath As String Dim wbFileName As String Dim fromWorkbook As Workbook...

Hi, I need to get a pivot row header name to another cell if another cell matches. DETAILED EXPLANATION: Se example of pivot table below. I have two sheets, lets call them "data" (sheet with pivot table) and "result" (without pivot table). If any text in C:C (in "result") matches any of the...

I have a table of 1000 students (names in Column A) and roughly 100 courses (in Row 1) and a list of IDs for the students unique to their respective course. I am given an ID for a student and I need to access the students name and the respective course. For instance, I may receive H19 and I...

Man, do I ever feel like a failure. I have a bunch of files in which I size the total width and height of the worksheet to fit into PowerPoint slide without requiring any resizing. However, some of the files that I work with have differently formatted column & row headings which means the width...

Hey everyone, I have been working on this problem for a while and cannot find an easy solution to do it without VB. If possible, I'd like to use a formula for it. I will accept VB answers though if you have them. I have a database that is about 600x600. I already have a function that finds...

Hi, I need some help. My table is structured similar to a calendar, for example, my column headers are the days from Sunday to Saturday, my row headers are the months from January to December, and the contents of my table are the days of the year from 1 to 365. I need a formula such that when...