transfer cells from sheet to another sheet

A

abougabal

Dear

I use excel in my job. I want to learn me how can I create page for
every customer automatic.

I have saleing analysis. Every day sale to 20 customers. I need only to
transfer the quantity to customer page automatic I have more then 40
customer I can create the pages for every customer. Try to help me how
I can let excel transfer the data from sales analysis to customers
pages automatic

Thanks

Hossam
 
N

nilizandr

Do to the new customer page, click on the cell where you want to hav
the transferred information, press the = sign. Now go to the sale
analysis spreadsheet that has the data that you want to hav
transferred. Click on the cell that you want to display on the ne
customer page. Press enter.
If you want to transfer a whole column or row, you can now just clic
and drag on this original reference, rather than having to switch bac
and forth between sheets over and over again.
 
Top