Floating Spin Button between Spreadsheet Tabs

Learnbuddy

New Member
Joined
Nov 25, 2015
Messages
5
I'd like a spin button that is accessible no matter what spreadsheet (tab) I'm in. The button will be used to match columns of data with another column of data. The reason I'm trying to do this is because I cannot seem to find out how to match two columns of data... I need to match data with similar words and not exact matches. I believe I can do it using one cell at a time, but not the entire columns at once.
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Learnbuddy

New Member
Joined
Nov 25, 2015
Messages
5
I'm using Excel 2013 on Windows 7.


Data includes a lists of names in different formats. One column for example, contains cells that contain employee's shift number, a category, first name and last name... I want to match it with another column that contains first name, last name, or last name, first name. Then, I want to highlight cells that have a matching set of names, if not leave as is.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,780
Messages
5,470,726
Members
406,719
Latest member
ensbana

This Week's Hot Topics

Top