Transfer Data Between Sheets Automatically

[rcdavis28]

Hello Experts,
The MASTER sheet will have all of the entries of data. Simply, based on whatever name is chosen in column A in the master sheet; all the field data needs to be copied to the sheet name of the person.

For example, A2 has Jon and some relative data for Jon. So is there a way once a user selects Jon -> then finishes inputting all the other records, that information is automatically sent to the next available row in the Jon sheet? It needs to go to the next avaialable row and not copy over previous entries. Hope someone can help with this, becasue I have been trying to figure this out for a bit. i know my code is a terrible approach for this.

Thanks!

[mehmetcik]

That is easily done.

Before looking at your data or your code.

The Process is:-

Use a Worksheet Change Macro to log the changes on your master worksheet.

When all fields are complete, the worksheet macro calls a main macro that copies the data to the user sheet.

Not to hard really.

[xladept]

Here's a double-click event for your Master sheet module:

Please Login or Register  to view this content.

[rcdavis28]

Thanks for your reply, but would you be willing to illustrate? I do not understand what you are referring to or how it works.

[mehmetcik]

Ok so.

All Cells A to G must have data................................................................

Right Click on the name "Master" at the bottom of excel and select view code

Paste this code into the module that opens and close it.

Please Login or Register  to view this content.

Then Select the developer tab
Select Visual basic and then project explorer
Select your workbook from the list
Then select insert module

paste this code into the module that opens and close it

Please Login or Register  to view this content.

[rcdavis28]

keep getting an error " Compile error: Sub or Function not defined " And it highlights in blue the Transfer (R) part of the code?

[nigelog]

works in attached workbook

[xladept]

Thanks for the rep! Here's a slightly safer version:

Please Login or Register  to view this content.

[rcdavis28]

Thank you all so much!

[Vraag en antwoord]

Two alternatives without variables

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

[xladept]

You're welcome!