seal

  1. AndrewMB

    Using cell value as filename to return a value from a closed workbook

    Good evening everyone, I have a list of filenames in column A. The list is long. In another column I want a generic formula I can drag down that will return a value from the same cell in each of those files. Currently, they are written manually like this; =('P:\FORD BUSINESS UNIT\Quality\FORD...
  2. A

    Return Heading Value (Title) to multiple Columns

    Hi, I have a worksheet that contains 119K lines and 150 columns. All the column headings are unique and the columns contain specific information and data about that particular product. Some products contain data from multiple columns. Eg below - Oil Seals - contains dimensional date in 4...
  3. J

    User form data validation

    Morning all As part of a user form I am developing the user has to enter a seal number , but it has to be on the seal list . The list has 3000 numbers , How can I make sure the user only picks a number off the list ?

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