Excel: Filling one table with data from another table

Hello everyone,

I have a question and hope you could help me

Let me explain my situation and what i need to achieve.

So, i have a table "X" which is populated daily with new entries with many data in eache column(client name, client id, client adress, order date, ordered product, prodouct details, delivery date, invoice date etc). In onother table"Y" i want that some of the colomns data entered in table "X" to be automatically filled. i mean that every time i enter a row in table x to be automatically filled in table y. The colomns position is not the same in table x and table y. In table y i need only (Client name,client adress, order date, delivery date, ordered product, product details).

Is there anyaw to do this without needing VBA because i am not very good at it

Thank youn in advance for your help !

Yes, you could do this with a few formulae, but it would help if you attached a sample Excel workbook.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post. Don't try to use the Paperclip icon (Attachments button) as this does not work on this forum.

Hope this helps.

Pete

Hello Here is the Sample of the file.

Hello Zer0Cool.

Thanks for your reply. Well for the moment the amount of informations and the formulas i will be using are not significant enough that it will impact the speed of the file. with the time i might consider doing it with VBA but as i said above i am not very good at it thats why i asked if there was a way to do it with formulas. I posted a sample of the workbook to help and give an idea of what i want to achieve.


[I]

Your file shows 9 records in the Data-X sheet, but only 6 in the Analyse sheet.

Do you want to copy all the records into the second sheet (with a reduced number of fields, and in a different order), or is there some condition that you want to apply, to have a reduced number of records?

Pete

Hello,

In Sheet Y it is a reduced number of data (rows) because i just wanted to give an idea of what i wanted to achieve and the relations between the columns in sheet X and sheet Y.

What i want is to copy all rows automatically to sheet Y based on the relationship between columns. Every time there is a new entrie in sheet x the data is to be copied/entered to sheet y automatically.

Sheet X is database for sold products and sheet y i will use to make a profitability analyses based on product and sale conditions.

i dont know if i was clear enough.