mapping cells

Hi, One of the challenges that some of us are facing is data mapping and I'm sure some of the respected members here have some solutions or suggestions. What I have is below example and what I need is to know if there's anyway that I can automate the cleaning by a formula? The company name...

Hi, I am in the process of moving data from one platform to another. The source data contains some 8-9k rows with 20 colums. The destination will have the same amount of rows (I expect max 500 to be dropped as they are outdated). However, the fields (colums) in the destination are slightly...

Hello, I control a workbook that I update the majority of however I want to allow a select number of people to update certain parts without the need to share or remember passwords. I have linked a text box from the read only file to a seperate file that people can update and save but as they...

Hello, I am in a bit of a strange predicament, where the column headings on my system A generated report do not match the column headings that I NEED on my import sheet for system B. Also, the system A generated report has additional columns that I don't need. I have two worksheets... "2 -...

Hi, I'm facing an issue with respect to running an index match on a set of datapoints. Description of the problem is as follows: <tbody> Name Skill1 Skill2 XYZ BPM Leadership ABC Content management Network operations </tbody> <tbody> Assignments Skill1 SKill2 SKill3...

Hello, I have a system that generates a report in an excel file that has two columns “Services” and “Product” however the services against the product are not correctly mapped. Hence, I need a macro to map the correct service against the product. I have added two tables below 1) The data I...

Hi, I have two columns of data in excel. There is no common values between these two columns. Few values in column1 is mapped manually with values in column2. Now i need to display both columns with mapped and non mapped values. I attached a sample sheet with this. Thanks Regards, Kannan S...

Hopefully this is in the right forum. I have over 50 different sets of data in CSV format containing clients information. I want to create a MASTER FILE with all this data in one place. Problem I have is two fold :- Not all files are in the same order of Columns , eg one might be TITLE...

-- removed inline image --- I have to enter the next value in column D to the cell D1 e.g. if the next value entered is 1000 in D4 then the value in cell D1 should be 1000 again if the next value entered is 23 in D5 then the value in cell D1 should be 23 Thanks in advance for anyone that helps