Mail merge from Excel to Excel

hello

a kind of mail merge from excel to excel.
That's not exactly what you want. In fact, you can create a tab for each client (accessible via hyperlink).
You create your client profile template, trying not to forget anything, and then you put formulas to retrieve the data from the general tab.
Thus, your profiles will always be up to date.
With your template, you create a copy of the tab for each client: this is possible with a small macro.
--

always zen

Hello gbinforme,

That's exactly what I'm trying to do. But unfortunately, I don't yet know how to use macros. Is there a link to a site that could explain this clearly enough?

Thank you
Hakim

Hello

Maybe here: it's quite comprehensive
--

always zen

Hi gbinforme,

I looked at the docs on the tutorials and it does seem very comprehensive, thank you.

I started reading but it is quite long.

I started with a simple macro and I can't find how to make the macro create the client file that I ask for. It always recreates the file I created during the recording.

Thanks
See you later
Hakim

Hello

To create a new tab: Sheets.Add.Name = "client sheet"

--

always zen

Hi gbinforme,
Is there a way to name the sheet using, for example, the first cell of the relative reference?

See you,
Hakim

P.S.: Thank you gbinforme for responding to my post.

1- In the sheet where you will create the form, create a dropdown list containing either the order numbers of the clients or their names - whichever you prefer - that returns a value representing the client's order in a cell (A1), and make the font color in this cell white so that it does not appear when printed.

2- Once the form is complete, place the formulas (VLOOKUP) in the cells that change from one client to another, as in the example:
VLOOKUP(A1, CLIENT DATA TABLE RANGE, column index number, 0).

N.B: The first column of the table must contain the order numbers of the clients (1, 2, 3....)

Hello

The title is incorrect: mail merge is done with Word or Writer, not Excel or Calc
--

Always zen