match cells

I am hoping someone can assist with creating the macro I am attempting. I would like to have explorer open, allowing me to map to the file location to pull the file in. Once the file is opened I would like the macro to organize the data so that like coverage names are placed in the correct...

Hi, First time here, I hope somebody can help me. I have 2 Columns, in Column A I have a string that is 12 characters in length (fixed), in column B I could have exactly the same string, I need to make sure that A2 string = B2, A3 =B3 etc..... if I use the exact function this replies with a...

Hello all, Thanks in advance for your help. But I have a predicament. I need to report back cell in Column1 = all instances of Column4 based on the match made between Column2 & Column3. Columns 1&2 are directly 1:1. Columns 3&4 are also 1:1. Columns 2&3 will have multiples of the same...

Hello, I have a REIT summary worksheet which contains different account names starting from Cell A4. Within the whole workbook, there are also different tabs, each named by the account name and contained information of that account. I would like to build a macro which find the account name...

let say i have 2 sets of data in sheet 1. Column A and E is date, B and F is invoice number, C and G is the amount due. A, B and C is issued, and E, F and G is received. some of the data in column ABC will not have in EFG, as the payer will have omitted some payment. what im trying to do is to...