Need a formula for excell

If i have 2 different sheets with 10 headers (eg “Coustomer name” “invoice number” and “insurance name” etc). I was to copy whatever the information is updated in any row under the specific header then it should be pasted on sheet 2 under the same header in same row and cloumn. (eg In sheet 1, column1 of row1 is my header “Customer name” and in sheet two row1 and column 3 is customer name. whenever i enter anything in column 1 row two then the same thing must copy to column 3 row 2.) I’ll be very thankful to you if you could help me with this.

 

 

By: Ankush Pathania

Leave a Reply

Your email address will not be published. Required fields are marked *