I am looking for help transferring information from one excel file to another automatically. I use one excel sheet that has 50 rows I use as a form when clients check in with a client code and use a vlookup formula to get there name, address, ect from another file. I am looking for a way to automatically transfer when I input their client code to another worksheet to the next open line that I use to track how many times they visit and amount paid.

How do you move information in Column A (where I input the client code) and amount paid in column B to a different workbook automatically each time I input a client code in column A. Right now I input the client code in both worksheets when they come in and print out the form sheet nightly for my records and delete it and use it the next day.

Any help would be appreciated. Some of my employees don’t do both and its causing a problem with my records.