Input Automation

[flamingogaslight]

Hi, can someone please help me the coding for this?

File 1 Name: Service Log
Consists of:
Column A with header "SR"
Column B with header "Receipt Mode" (Has data validation)
Column C with header "Company Name"
Column D with header "Segment" (Has data validation)
Column E with header "Created Date" (Has date format)
Column F with header "Service Type" (Has data validation)
Column G with header "Enquiry Type" (Has data validation)
Column H with header "Sub Enquiry Type" (Has data validation)
Column I with header "Remarks"
Column J with header "SR Status" (Has data validation)
Column K with header "Closed Date" (Has date format)
Column L with header "Aging" (Has IF formula)
Column M with header "Name" (Has data validation)
Column N with header "CIF"
Column O with header "Complaint" (Has data validation)
Column P with header "Over SLA" (Has data validation)
Column Q with header "Source" (Has data validation
Column R with header "Department" (Has data validation)
Column S with header "Branch" (Has data validation)
Column T with header "Staff Name"

File 2 Name: Master Service Log
Column A with header "SR"
Column B with header "Receipt Mode" (Has data validation)
Column C with header "Company Name"
Column D with header "Segment" (Has data validation)
Column E with header "Created Date" (Has date format)
Column F with header "Service Type" (Has data validation)
Column G with header "Enquiry Type" (Has data validation)
Column H with header "Remarks"
Column I with header "SR Status" (Has data validation)
Column J with header "Closed Date" (Has date format)
Column K with header "Aging" (Has IF formula)
Column L with header "Name" (Has data validation)

There are actually 8 files which are the same as File 1: Service log all of the files are saved in the same folder including File 2: Master Service Log. I would like to make it so that whenever a new row of data is filled in the service logs file, it could be automatically added to File 2: Master Service Log on the very bottom row every time.

However, the columns are different as stated above. I would like for only the relevant data from File 1 to be added to File 2 (e.g. column I1 with header "Remarks" from File 1 would be copied to H1 with header "Remarks" in File 2) and the data validation, formulas and date formats should not disappear as it is being automatically inputted to File 2.

 

[mumps]

It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach screenshots (not pictures) of your Master sheet and at least one of the other 8 files including some sample data. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).