corresponding cells

  1. D

    Find Minimum Value, Then Write Out All Corresponding Information

    Hello, I have a list of cities with distances and travel times between them. Postal Code is only for further identification of the city or city part. The table looks like this (with a total of 60000 rows): <tbody> Postal Code 1 City 1 Postal Code 2 City 2 Distance(km) Travel time(minutes)...
  2. F

    pop up box with conditions based on cell value. is that possible?

    Hello again, I seem to be hitting another wall in my excel project. I have a box I have created in Excel 2013 when I click on the command button to input information on a specific sheet. The code reads as follows: First code is for the OK button. Second code is for the input boxes to go to the...
  3. K

    Find last number in a column and find the corresponding last depth.

    Hi there- So my company uses an old school database (with Access 97 .mdb files) to create reports. I want to bypass this old database and create my own working excel spreadsheet. What I need to do with this is have a macro search the BHAID column and find the First #1 and the next...
  4. C

    Cell R8 links to cell S8. Change cell S8 across many sheets.

    Using excel 2007. I am creating monthly templates of Balance sheets and Income statements for many properties over a 12 month cycle. The original data entered was wrong for cell S8 which corresponds to cell R8. This happens throughout the entire sheet. So for the example, cell R8 is 1110-000 and...

Watch MrExcel Video

This Week's Hot Topics

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
Top