Search,update, and add details on master file

**emina002** · 06-15-2012, 02:11 AM

Hi i need a little help from you guys, kindly see attach file to visualize my problem, On my file I have MasterFile and File sheet, on File sheet are the details and it will update the master file based on this details, for example if the "Employee Name" exist on "MasterFile" sheet it will update only the Salary column on "MasterFile" if the employee name not on MasterFile it will add the details on it's respective department as you see the format of MasterFile,I want to achieved this using VBA/MACRO,thank you

**arlu1201** · 06-15-2012, 04:04 AM

Any reason why you have the MasterFile formatted this way? It will be much easier to maintain if you avoid merged cells and blanks in between.

Also, the department info is already present in column B, why do you have it again in column A?

**emina002** · 06-15-2012, 04:11 AM

That is the default format of Master File, it is like put details alternate or 1 rows must be empty before the details/data

.

**emina002** · 07-03-2012, 02:06 AM

I just modified the file and what will be the final output,kindly see attachment please. Is there any way to updated it even though the master file has a plenty of empty rows?

As you noticed,master file looks organized since the output/design is alternately compose of data and empty rows

**arlu1201** · 07-03-2012, 03:55 AM

I tried working on the code for you but its getting pretty messy.

I have a solution in mind but it can take a lil while. What i plan on doing is - Copy the contents of Masterfile and File to a new temp tab, compare them line by line and then re-input values into a fresh MasterFile.

Will this work for you?