data mapping

  1. Z

    Ideas and suggestions are needed!

    Hello, I have a file that has IDs and Dates and I need to map this file to multiple excel sheet files that are more than 20 files with protected password. Any suggestions to get this done in easier way rather than open each file and copy and paste into a master file? Thanks, Zina
  2. T

    Merge duplicate and similar rows into new sheet

    The initial part of my query is similar to some other posts (although I am not adept enough at VBA to modify the code as needed to suit my purposes), but because the second part goes beyond what I've been able to find already on the forum, I thought I'd post the whole question here. I'm working...
  3. Z

    Mapping file

    Hi, I have a file to map from a different excel file. The common field in both files is the email address, however, some cells have more than one email address. Below is the sample data and here's what I need to get: Is to fill column F with the right team from columns A & B, and if there's...
  4. C

    Data Validation & Drop-Down Lists

    Hi All, I have a drop-down data validation question. I have 5 columns that users are required to fill out when adding a new row. I'd like the help the users by adding drop-boxes that will narrow the choices down for them and reduce inaccurate mapping. I've figured out how to have dependent...

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