Forum Discussion

pmrkrr's avatar
pmrkrr
Copper Contributor
Feb 09, 2022

Information from one sheet to several others

Hello everyone! I am struggling with my customer handling excel.

1. The first sheet contains the customer information: all personal information, what has been previously ordered and new order informations.

2. The second sheet should collect a customer register with first name, last name, date of birth, address, phone, email, marketing information. The data should come from the first sheet. I know of course how to get one persons information there but what should I do when I would need it to pick from multiple "customer cards" some of the information for the register. 

3. The third sheet contains the bill, and the bill of course needs the price and customer information from sheet nro 1.

 

Hopefully the pictures shows enough o what I mean.

Because the build of the "customer card" the cells are here and there, and I do not know how to manage this. Should I have one base "customer card" that I always copy with looked cell somehow  I do not know how to do this)? So that when I copy a new card, certain cells information will end up in the sheet 2 and 3 on correct places? HELP! Grateful and thankful for any help!

 

Best Regards,

Pia

Resources