| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Match data in separate columns!
Hi can someone please give me a little advice on the following, hopefully if is a simple problem. I have a range of data but am only interested in rows where the cells in two specific columns are equal. Therefore I want a macro which will looks through the data and highlights any rows which have the same value in columns 'B' and 'H', then copies and pastes this data in another worksheet. Any help would be very much appreciated, Thanks kindly, Andrew -- Shandy720 ------------------------------------------------------------------------ Shandy720's Profile: http://www.excelforum.com/member.php...o&userid=26230 View this thread: http://www.excelforum.com/showthread...hreadid=479065 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I match data from two separate files in excel | Excel Discussion (Misc queries) | |||
| Using Index & Match functions to find data on separate worksheet. | Excel Worksheet Functions | |||
| Separate data into two columns | Excel Discussion (Misc queries) | |||
| Can I use Excel to match text data from 2 separate columns ? | Excel Worksheet Functions | |||
| Match data of two identical strings in two separate spreadhseets | Excel Discussion (Misc queries) | |||
![Shandy720[_8_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
