I'm working in excel and on one spreadsheet and I'm having to retype everything on to another spread sheet, I want to be able to have my data transfer to another spread sheet at a trigger cell. For example
Spreadsheet A has the client's info, payment, appointment, date, doctor and a lot of other details and finally "how much the client owes" in "how much the client owes" I want it to automatically trigger just the info I listed above to Spreadsheet B.
In other words,
What I want transferred to Spreadsheet B is all of the above info but I want it transferred ONLY when I type in the amount the client owes in Spreadsheet A. Once I type that in Spreadsheet A, I want all of that to transfer to Spreadsheet B.
How Can I make this happen?
Thanks in advance for any guidance!
How can I transfer data from one spread sheet to another?
I think that I have understood your requirements. The active column is Column F which I have titled "Owing". Place the dollar value in each cell of Column F then click away from the cell and the client details should transfer to Sheet2.
I have included a line of code to delete the details from Sheet1 that are transferred to Sheet2. I am assuming that in your actual workbook you would not want to duplicate all client details and clutter up your data entry sheet (Sheet1).