I'm new to the forum and also a VBA apprentice. I'm building a workbook but as I'm an apprentice and I have little knowledge, I'm asking for your help to build a macro. If it's not possible, I understand and appreciate it. Sorry for the English. It's not my native language. There are several dozen worksheets, but I just illustrate it with three options to explain the problem.
The first worksheet (BASE) is the list of people and their ID. The DATA worksheet is where I enter the data. The other worksheets I named it with each person's name. The criteria is to copy the data from the DATA worksheet, and save it in the worksheet corresponding to the name. For this I need a macro to be able to identify the worksheet where it should save the data that corresponds to the name, which is in the DATA worksheet. The data must be pasted on the last blank line.
To identify which worksheet, I thought of writing “NAME” in a cell and concatenate this cell with the variable that is in the worksheet's name field DATA. This would result in a name equal to the worksheet where the data should be saved. The macro would then use this result as a way to identify the target worksheet. The ID is automatic. PROC. Nº, DATA and PRODUCT CODE are manually entered by me. In the attached example I already include my idea.
Could someone help me to create a Macro with these functions? Can you give me other ideas?
Thanks and sorry for the long text.