header columns

  1. E

    Populating Dynamic List of Machinery Checks from Column Headers...

    Hi All - As an extension of a previous post... I've tried a few methods on this one and can get it working in principal, but hit snags with the row and column referencing dynamically... I would like a list of machinery safety checks, to populate dynamically based on them having an 'X' against...
  2. govind_bhuse

    Fetch last drawn salary month in excel

    I have a list of employees and their month wise salary drawn. I need the "last salary drawn" & "month name" for all employees. The needed result is given in column H & I. Can we do it using excel formula ?
  3. A

    Select range in for loop

    Hello, I have a sheet with 35 columns. I would like to create a For loop to go through all the headers of these columns, find a specific one and return the column underneath it as a Range. I have tried Dim rng As Rang With Sheets("MySheet"). UsedRange For i = 1 To .Columns.count If...
  4. G

    unlock row header

    I already have column header row (that is ediable) in a particular spreadsheet. But when I import data from Access into to the spreadsheet, say starting at row three, I get the access table header row that is uneditable and unremovable. Right click on the access table header row gives a greyed...
  5. S

    VBA - Userform - Pulling data into the userform by looking for a header record and not using a named range

    I have a userform that will pull the data in from a sheet, but the sheet does not have named ranges. I am using header records instead (i.e. Main_Fruit). The problem I am coming up w/ is when I try to extend the dependent combo boxes to show specific data for the options chosen in the first...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top