matching columns

Hello Team, i need to reconcile two sets of data and match them side by side on same sheet , the data are on different sheet Is there any macro to facilitate this tasks instead of using formulaes (lookup) Sheet 1 Sheet 2 The common data are in the column D in ''sheet 1'' and Column E in...

Hello all! I'm working on a workbook where I need to match data and if the match is found, input a value. The workbook has two sheets - Sheet1 and VideoTracking. Here's what I'm trying to accomplish... Find an email match - match column F (VideoTracking) to column F (Sheet1[Provider Email ])...

Hi, I have two sets of data, one is a column with a certain set of numbers, lets say 11111 33333 55555 Then, i have a second set of data, that is partially made up of this first set of numbers. Each number is matched up with another column. it looks like this: 11111 abc 22222 def 33333 ghi...

I am working on some vlookups from a Pivot table that has five results on them; however some of the results are null, so the column disappears. I have been able to link it to the grand total, which is what I want, just not to sure how I can get it to link on the columns. This is my statement...

I have code to copy rows of data to another sheet if the cell in column L equals "High" or "Extreme". I'm unsure how to copy only certain columns of that row to the new spreadsheet, which has matching headers in place. I'd like to either copy columns 2, 3, 6, 12, 14, 18, and 21, or have the code...

Hey Everyone I really hope someone can help me with this! I am doing a VLOOKUP match-up between company names in one column, and company names in another column. The company names have an inconsistent format (like HeroSwap, Inc. in one column and HeroSwap Incorporated in the other). I've...

I used a few split text functions, (aka: right, left, find) and split the text into what I finally wanted. Now I want the new column of text to equal another column and only some of the text is matching up. For example, it kind of looks like this: First Column Split Column...

Hey Everyone, this is my very first thread here please excuse any novice actions I may make while posting this, thanks. I have about a dozen spreadsheets (we'll call these the "Dirty Dozen") that all have product Sku's in column A and have a column for Product ID's in column B but no actual...

Dear friends, I have 2 system generated Excel files that have certain combinations and prices against those combinations. The 2 Excel worksheets are based in the following format: Column A - Unique system generated ID, these IDs are different in both the sheets. Column B - Pricing Parameter...

I have 3 columns two cloumns are ACCT numbers and third is comments Column A has a longer list of acct numbers than does B, But column B had the same amount of rows as does C,(I copied and pasted from another sheet) How can i match A to B while still keeping C intact to B? Column A...