column header

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...

Hi, I have two work sheets. The first one (varEoD) contains the data set and the second one varYTD will only be a select 6 columns that I have defined. I want to transfer all rows in varEoD to varYTD that correspond with the 6 column headers. I am getting the "Run Time Error 91: Object...

Hi, I have a macro that currently sends all my data from a master spreadsheet to individual worksheets. It uses a column header to determine what data goes to what worksheets. The only issue I have is that this formula doesn't maintain formulas, it pastes values instead. Does anyone have a...

What function or formula can i use for column labels with Part common title e.g. Plan in (Plan Q1, for Plan Q2, Plan Q3 and Plan Q4)?

Hi Readers, My problem arises from the fact that I run macros on a report where the columns keep changing places. I need a macro which can Locate a particular column called PACE 1 Insert a formula from the first row under the PACE 1 column The formula needs to be such that If there is a...

On a particular worksheet within the workbook I have a bunch of pivot tables (excel 2007). The column header is "Wk Ending". This is the item that I need to filter. I used the code i show below. When I update the "Wk Ending" field all of the other pivot tables completely lose the filter. They...

Hi All- I've searched the web but surprisingly can't come up with an answer for this simple question: Does Access 2010 have a limit on the number of column headers in crosstab queries? If so, what is it? I know that Access 2007 is limited to 255. I need to run multiple crosstabs with ~700...

What I am trying to do: - Create an add-in that does a simple extended cost calculation = (unit_cost) x (units_per_pack) x (packs_per_carton) - I want the calculation to be based on the column header (always in row 1) rather than column A, B, or C because in different spreadsheets the columns...

Hello; I currently have a spreadsheet that contains 84 column headers (A1:CF1). What I want to do is ensure the source file has not been altered (columns added, deleted, moved) before I start scraping and wrangling data. My current approach I know is a very long way around the problem where...

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...

I need help modifying the code below. I know this should be easy but I have very little experience with VBA. What I want to do is change the code to evaluate a column with the header "jobnbr" instead of “column A” in my worksheet. The column may change locations in my worksheet but the header...

hello, here is my question: <TABLE style="WIDTH: 310pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=409 border=0 x:str><COLGROUP><COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 2157" width=59><COL style="WIDTH: 38pt; mso-width-source: userset; mso-width-alt...