Create a sub-table in an Excel spreadsheet
Marissia
-
via55 Posted messages 14730 Registration date Status Membre Last intervention -
via55 Posted messages 14730 Registration date Status Membre Last intervention -
Hello,
I need to create a database in Excel.
To do this, I have set up a table with several columns and names of countries. I need to create a table in each column or, if possible, export the table that already exists in WORD and insert it into the appropriate country's column in Excel while taking into account the existing columns in Excel.
Can someone guide me on how to do this because I am completely lost?
So, it's about inserting or creating a table containing multiple data points in a column of an Excel table.
Thanks in advance to those who can help me.
Marissia
I need to create a database in Excel.
To do this, I have set up a table with several columns and names of countries. I need to create a table in each column or, if possible, export the table that already exists in WORD and insert it into the appropriate country's column in Excel while taking into account the existing columns in Excel.
Can someone guide me on how to do this because I am completely lost?
So, it's about inserting or creating a table containing multiple data points in a column of an Excel table.
Thanks in advance to those who can help me.
Marissia
1 réponse
Good evening Marissia
You must first construct your table in such a way that it matches the data to be imported, for example if your table in Word has 6 columns per country, you need to create an Excel table with 6 empty columns per country; then it's just a matter of copying and pasting from Word to Excel
Best regards
--
"Imagination is more important than knowledge." A. Einstein
You must first construct your table in such a way that it matches the data to be imported, for example if your table in Word has 6 columns per country, you need to create an Excel table with 6 empty columns per country; then it's just a matter of copying and pasting from Word to Excel
Best regards
--
"Imagination is more important than knowledge." A. Einstein